Defining a Variable

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> Hi Phil,
>
> The error suggests that a userform named frmCalendar was not found.
>
> Check that the forms name is correct.
>
>
> ---
> Regards,
> Norman
>
>
>
> "Phil H" <[email protected]> wrote in message
> news:[email protected]...
>> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>