Thread: Call Userfor and click button with macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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


Reply With QuoteReply With Quote