Hey everyone! got a pretty silly question.
I just need to have a pop up that asks for you to enter a date. The date that you enter needs to then be entered into specific cells (B2 - B93). Thanks in advance for all your help!
Hey everyone! got a pretty silly question.
I just need to have a pop up that asks for you to enter a date. The date that you enter needs to then be entered into specific cells (B2 - B93). Thanks in advance for all your help!
If you are going to be the only one using it you can use the native calendar control.....if you are going to share it with others I would suggest a different approach
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Here is a thread with a discussion of issues surrounding the acitveX calendar control.
Click here
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
[VBA]Sub dates()
Range("B2:B93") = CDate(InputBox("Enter date dd/mm/yy"))
End Sub
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
I'm sorry, I should have read the question.....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
THANKS everyone, code worked perfectly!