E ExcelMonkey Feb 25, 2005 #1 Is it possible to call a userform and click its ok button without actually displaying it? Thanks
C Chip Pearson Feb 25, 2005 #2 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
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
E ExcelMonkey Feb 25, 2005 #3 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 message news:[email protected]... . Click to expand...
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 message news:[email protected]... . Click to expand...
