Call Userfor and click button with macro
 

Is it possible to call a userform and click its ok button
without actually displaying it?

Thanks

Call Userfor and click button with macro
 

Change the Click event procedure's declaration from Private to
Public, and then user code like the following:

Load UserForm1
UserForm1.CommandButton1_Click


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"ExcelMonkey" wrote in
message ...
Is it possible to call a userform and click its ok button
without actually displaying it?

Thanks

Call Userfor and click button with macro
 

Thanks


-----Original Message-----
Change the Click event procedure's declaration from
Private to
Public, and then user code like the following:

Load UserForm1
UserForm1.CommandButton1_Click


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"ExcelMonkey" wrote
in
message ...
Is it possible to call a userform and click its ok
button
without actually displaying it?

Thanks


.