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

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

Hi Phil,

Verify also that the OpenCalendar sub is housed in a module in the same
workbook as the userform.


---
Regards,
Norman



"Norman Jones" wrote in message
...
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

You are correct. I renamed the form and neglected to take that in to
account. Thanks for the help

"Norman Jones" wrote:

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