Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,522
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Entry Form - Execute if value is not 0 [email protected] Excel Discussion (Misc queries) 6 July 1st 09 04:57 AM
Excel Formula Doesn't Execute (Shows formula-not the calcuation) Keys1970 Excel Discussion (Misc queries) 4 November 15th 06 02:12 PM
VBA Formula Fails to Execute Patrice Stewart Setting up and Configuration of Excel 1 August 24th 05 09:45 PM
Execute VB Form from Excel Ed[_18_] Excel Programming 1 June 1st 04 06:07 PM
execute a text as a formula Suresh[_4_] Excel Programming 1 April 20th 04 03:42 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"