Need VB formula to execute form

D

dave

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
 
D

Don Guillett

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
Click to expand...

Look in the ThisWorkbook module for workbook_open
 
D

dave

Look in the ThisWorkbook module for workbook_open
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VB formula to exit workbook 1
Need VB formula to retrieve data 19
EXCEL - IF(IFERROR(VLOOKUP question 0
Need VB formula to edit and save data 2
concatenate within an excel formula 3
Access Click in Table to Open Form 0
Running Report_Open Code 7
want to track time while paste value in multiple column of same roe 1

Top