 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2006Date Pop Up
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!  SignatureStompS Portland, OR http://www.geocities.com/pdxinvestr/Stomps.html http://www.rondebruin.nl/calendar.htm SignatureRegards, Peo Sjoblom Portland, Oregon >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! > http://www.rondebruin.nl/calendar.htm > >>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 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 >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 [quoted text clipped - 3 lines] >>>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! 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 >I tried this on my sheet and got runtime error 424 and debugger sent me to >this line (third last on the routine) [quoted text clipped - 8 lines] >>>>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! Hi Calendar1 is the name of the control If you add more then one control you get different names SignatureRegards Ron de Bruin http://www.rondebruin.nl > 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: [quoted text clipped - 10 lines] >>>>>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! Sorry, I'm not sure what you mean... > Hi > [quoted text clipped - 19 lines] >>>>>>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! 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 SignatureRegards Ron de Bruin http://www.rondebruin.nl > Sorry, I'm not sure what you mean... > [quoted text clipped - 18 lines] >>>>>>>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'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...... > Hi StompS > [quoted text clipped - 32 lines] >>>>>>>>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! Hi Try the steps again in a new workbook SignatureRegards Ron de Bruin http://www.rondebruin.nl > 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...... [quoted text clipped - 31 lines] >>>>>>>>>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! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.