ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need VB formula to execute form (https://www.excelbanter.com/excel-worksheet-functions/339826-need-vbulletin-formula-execute-form.html)

dave

Need VB formula to execute form
 
I need VB code to execute the form straight away when the file is open
instead of click the button on the sheet to execute the form. Any
solution?

Thanks

dave

Don Guillett[_2_]

Need VB formula to execute form
 
On Jan 22, 5:31*am, dave wrote:
I need VB code to execute the form straight away when the file is open
instead of click the button on the sheet to execute the form. Any
solution?

Thanks

dave


Look in the ThisWorkbook module for workbook_open

dave

Need VB formula to execute form
 
On Jan 22, 12:33*pm, Don Guillett wrote:
On Jan 22, 5:31*am, dave wrote:

I need VB code to execute the form straight away when the file is open
instead of click the button on the sheet to execute the form. Any
solution?


Thanks


dave


Look in the ThisWorkbook module for workbook_open


Cheer Don. It work. Can you help with 1 more formula. I want the work
book to be closed when press the close button. Do you know what is the
formula?

Thanks

Dave


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com