Form
 

Hi,

I would like to set my form as I set a worksheet however I get a type
mismatch.
My book does not list a form as an object and I do not see 'Form' as an
option on the Dim statement. I'm not using it so much as in a with statment
but I would like to type the name of the form once in the beginning and use a
variable in the code.

Can this be done?

Thanks
--

Karen

Form
 

Dim frm As Userform1

Set frm = New Userform1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Karen53" wrote in message
...
Hi,

I would like to set my form as I set a worksheet however I get a type
mismatch.
My book does not list a form as an object and I do not see 'Form' as an
option on the Dim statement. I'm not using it so much as in a with
statment
but I would like to type the name of the form once in the beginning and
use a
variable in the code.

Can this be done?

Thanks
--

Karen

Form
 

Thanks!
--

Karen


"Bob Phillips" wrote:

Dim frm As Userform1

Set frm = New Userform1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Karen53" wrote in message
...
Hi,

I would like to set my form as I set a worksheet however I get a type
mismatch.
My book does not list a form as an object and I do not see 'Form' as an
option on the Dim statement. I'm not using it so much as in a with
statment
but I would like to type the name of the form once in the beginning and
use a
variable in the code.

Can this be done?

Thanks
--

Karen