If you want the user to input a date in a Userform, you could of course just use a Textbox. But you'd have to write a lot of code to check whether the user put in a correct date, in the correct format, within the allowed timeframe, etc.

Left Single The distance between a control and the left edge of the form that contains it, in points. Value Variant Sets the currently selected date.

I have seen some suggestions here but none have worked for this particular problem. I have reset the menus and renamed the.xlb files and neither helps.

Mine has Office 2010, so I think there might be an issue with the file itself. Also, not just copy and paste. I can also just click the top cell after filling in the formula and then drag the bottom right of the cell downward and it will do the same of filling in the correct formula, but have the incorrect value. I know that I could get him to just click save each time before really looking at the results, but that is just a band aid to the problem. Any ideas how to fix this? I'm trying to come up with a solution to calculate the man hours and days worked over multiple sheets. I have a file that has 8 sheets.

I hope this makes sense. Thank you in advance for any help.

• You can set this dates are selectable or not. Patch sketchup 2016 pro. • There can be any number of this arrays. • Latter is stronger: if a date is in multiple arrays, the attributes (color and selectable) of the latter added array will be effective. • The dates can be added as Variant arrays or as Excel Range objects (In latter case the Variant array will be exctracted by.Value2 function.) (Note: The algorithm is looking at the whole array - there can be empty values -, so you may not want to use B:B-like ranges.).