|
Posted to microsoft.public.excel.programming
|
|
|
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
.
|