PDA

View Full Version : How to enter date into pop up, which enters into spreadsheet



truzilla
06-12-2008, 07:55 AM
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
06-12-2008, 08:01 AM
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
06-12-2008, 08:05 AM
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
06-12-2008, 08:16 AM
Sub dates()
Range("B2:B93") = CDate(InputBox("Enter date dd/mm/yy"))
End Sub

lucas
06-12-2008, 08:20 AM
I'm sorry, I should have read the question.....

truzilla
06-12-2008, 08:28 AM
THANKS everyone, code worked perfectly!