VBA issues with opening/finding source code

noisepoet

Board Regular
Joined
Oct 19, 2006
Messages
77
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?
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,052
Office Version
  1. 365
Platform
  1. Windows
Is it a typo that you have a . between frm and Calendar?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,278
Messages
5,571,282
Members
412,374
Latest member
Nagelgal
Top