|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
July 1st, 2005, 03:49 PM
|
|||
|
|||
Open forms in Excel?
I have created a user form called UserForm1 because I am so creative (JK). Anyways, I want to open by running a macro in Excel 2000. Here is my Macro:
Sub OpenUserForm1() 'This macro opens the user form UserForm1.Show End Sub However, I get the error, "Object required" . The funny thing is this is the exact thing both the help pages said to do and Microsofts website. I really must have missed something. I have tried MANY different things. Any help would be awesome. Thanks, theguz
|
|
#2
July 5th, 2005, 09:21 AM
|
|||
|
|||
|
Never mind I figured it out. In case anyone has this problem in the future here is what you do.
1. In the initalize event you must add Load Userformname UserFormName.Show 2. Then create the macro that says: Userformname.Show 3. Where there is bold put in your form name. I am not really sure why this is. If anyone knows I would love to hear the explanation theguz
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Excel VBA Question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
