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!
to typing it in....is this possible (and easy)? Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
S
StompS
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!
creating new ones (hopefully with a macro). How can I use this and have it
be part of a new worksheet? Thanks!
S
StompS
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
this line (third last on the routine)
ElseIf Calendar1.Visible Then Calendar1.Visible = False
S
StompS
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
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
R
Ron de Bruin
Hi
Calendar1 is the name of the control
If you add more then one control you get different names
Calendar1 is the name of the control
If you add more then one control you get different names
S
StompS
Sorry, I'm not sure what you mean...
Ron de Bruin said:Hi
Calendar1 is the name of the control
If you add more then one control you get different names
R
Ron de Bruin
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
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
S
StompS
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......
is also reference to frmCalendar. I believe I followed all the directions
from your site......
R
Ron de Bruin
Hi
Try the steps again in a new workbook
Try the steps again in a new workbook
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.