| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Call user form from ThisWorkbook; close file if form closed | Excel Programming | |||
| Pass variable from form to form to form | Excel Programming | |||
| Strange issue freezing parent form when unloading a child form | Excel Programming | |||
| Transfer data to form from Excel range upon loading of form. | Excel Programming | |||
| Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming | |||
Linear Mode
