noisepoet
Board Regular
- Joined
- Oct 19, 2006
- Messages
- 82
I have entered the code for a user form calendar to appear and enter the date into a cell. The code came from this website: http://www.fontstuff.com/vba/vbatut07.htm
I can get the calendar to appear from the user form "view code" screen (pressing F5 while on this screen). However, when I follow the instructions and enter the code into the module screen -- Sub OpenCalendar() fmr.Calendar.Show End Sub -- I get "Run time error 424: object required."
When I choose to debug, the frmCalendar.Show is highlited. I'm assuming this means that the module code is unable to recognize the user form code. I've double and triple checked the code, and there are no problems there. Could something else be wrong?
I can get the calendar to appear from the user form "view code" screen (pressing F5 while on this screen). However, when I follow the instructions and enter the code into the module screen -- Sub OpenCalendar() fmr.Calendar.Show End Sub -- I get "Run time error 424: object required."
When I choose to debug, the frmCalendar.Show is highlited. I'm assuming this means that the module code is unable to recognize the user form code. I've double and triple checked the code, and there are no problems there. Could something else be wrong?