user forms
Hi, is it possible for a user form to open automatically when the .xls doc containing it is opened? -- sam1 ------------------------------------------------------------------------ sam1's Profile: http://www.excelforum.com/member.php...o&userid=18280 View this thread: http://www.excelforum.com/showthread...hreadid=521537 |
user forms
Use the Workbook_Open event procedure. In the ThisWorkbook code
module, paste the following code: Private Sub Workbook_Open() userform1.Show End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sam1" wrote in message ... Hi, is it possible for a user form to open automatically when the .xls doc containing it is opened? -- sam1 ------------------------------------------------------------------------ sam1's Profile: http://www.excelforum.com/member.php...o&userid=18280 View this thread: http://www.excelforum.com/showthread...hreadid=521537 |
All times are GMT +1. The time now is 01:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com