Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any onLoad kind of function for Excel
Please help,
I am a novice to Excel programming. I wanted to define some variable and give their initial values and also add some form controls o loading of the Excel sheet. Is it possible to do it? Thanks Samee -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any onLoad kind of function for Excel
In VBA Environment, in the 'Workbook' add the following ...
Private Sub Workbook_Open() 'Do stuff in here End Sub "sameerce " wrote in message ... Please help, I am a novice to Excel programming. I wanted to define some variables and give their initial values and also add some form controls on loading of the Excel sheet. Is it possible to do it? Thanks Sameer --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any onLoad kind of function for Excel
Sameer,
More detail would be helpful, such as when do those variable need to be initialised, and will they be used in one macro. or many. You could create public constants and assign values if the value will never change, or public variables if they are required in many macros. In idealisation could be done in the Workbook_Open event or at the start of a procedure. As for the controls, it is probably better not to create the controls when a sheet is loaded, it could be loaded many times, but add them manually, and then just use them in the sheet. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "sameerce " wrote in message ... Please help, I am a novice to Excel programming. I wanted to define some variables and give their initial values and also add some form controls on loading of the Excel sheet. Is it possible to do it? Thanks Sameer --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for a function that performs a special kind of Vlookup | Excel Discussion (Misc queries) | |||
Some kind of Array-Sumproduct Function | Excel Worksheet Functions | |||
?? Some kind of look up function - Help and Thanks A Lot! | Excel Worksheet Functions | |||
can i make a "repeat until" kind of function in excel2003 | Excel Discussion (Misc queries) | |||
how do i plot this kind of data using excel | Excel Discussion (Misc queries) |