View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Defining a Variable

Hi Phil,

The error suggests that a userform named frmCalendar was not found.

Check that the forms name is correct.


---
Regards,
Norman



"Phil H" wrote in message
...
Using Option Explicit gives me the compile error: Variable not defined, on
this code. What would the correction be?

Sub OpenCalendar()
frmCalendar.Show
End Sub