Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Thanks!
--

Karen


Bob Phillips said:
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)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell values to an array, then array transpose to another workbook 8
Early binding problem 6
Button & Labels text Anti-aliasing Problem using Windows Forms C# 0
How to change add-in object from within worksheet module. 3
For Each Type mismatch 5
Open Specific Worksheet Using Button Form Control in Excel 0
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
Setting an array of text boxes equal to individual form text boxes 6

Back
Top