View Single Post
  #1   Report Post  
Ann Shaw
 
Posts: n/a
Default Calendar in Excel

Hi

I recently saw a nice little macro in a spreadsheet that
opened a Calendar on screen and by clicking on the
calendar, entered a date in a cell. I would like to do
this - I tried

Sub OpenCalendar()
frmCalendar.Show
End Sub

But this came up with Object error?????

Any ideas on how to do this but keep it simple - my
objective would be to attach this macro to a button on
screen which I have no problem with once I get the right
steps to show the Calendar.

Thanks a million in advance..

Ann