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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,075
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,119,070
Messages
5,575,968
Members
412,693
Latest member
SJC2020
Top