Date Pop Up

  • Thread starter Thread starter StompS
  • Start date Start date
S

StompS

I have a cell that would like a calendar pop-up to select a date as opposed
to typing it in....is this possible (and easy)? Thanks!
 
I think that would work great but I have multiple worksheets and keep
creating new ones (hopefully with a macro). How can I use this and have it
be part of a new worksheet? Thanks!
 
I tried this on my sheet and got runtime error 424 and debugger sent me to
this line (third last on the routine)

ElseIf Calendar1.Visible Then Calendar1.Visible = False
 
Okay, I realized that I didn't have the calendar created in VBA. I followed
the directions, created it, and now I get a 424 runtime error "object
required' and the debugger goes to this line:
Calendar1.Left = Target.Left + Target.Width - Calendar1.Width
 
Hi

Calendar1 is the name of the control

If you add more then one control you get different names
 
Hi StompS

When You insert a Calendar the first time in your worksheet it is named
Calendar1 (see how on my site)
When you insert a second it is named Calendar2

The code looks for Calendar1 and if your Calendar have a different name it blow

You can change and see the name in the Name box in the formulabar
 
I'm new at this, but it appears that the calendar name is calendar1. There
is also reference to frmCalendar. I believe I followed all the directions
from your site......
 
Back
Top