How to enter date into pop up, which enters into spreadsheet

[truzilla]

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!

[lucas]

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 (http://vbaexpress.com/kb/getarticle.php?kb_id=543)

[lucas]

Here is a thread with a discussion of issues surrounding the acitveX calendar control.

Click here (http://www.vbaexpress.com/forum/showthread.php?t=10914)

[mdmackillop]

Sub dates()
Range("B2:B93") = CDate(InputBox("Enter date dd/mm/yy"))
End Sub

[lucas]

I'm sorry, I should have read the question.....

[truzilla]

THANKS everyone, code worked perfectly!