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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,912
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,113,792
Messages
5,544,311
Members
410,602
Latest member
lidovi
Top