Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Load
I have created a user form that has several ComboBoxes.
What i want is for a default value to be present in the box when the file is loaded. I have managed to use the activate command to get this to happen if you change to a different worksheet and then back again. Using this code Private Sub Worksheet_Activate() ComboBox1.Text = "Select Model" ComboBox3.Text = "Select Coverage" ComboBox2.Text = "Select Coverage" ComboBox7.Text = "Select Configuration" ComboBox4.Text = "Select Configuration" ComboBox6.Text = "Select City" ComboBox5.Text = "Select City" But i cannot for the life of me understand how to trigger this action automatically when the file is first opend ! Any answer would be appreciated Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
csv, how to set excel to auto load | Excel Discussion (Misc queries) | |||
auto load data from one workbook to another | Excel Worksheet Functions | |||
File takes 40 minutes to load (auto-calculation) | Excel Discussion (Misc queries) | |||
Auto load macros | Excel Programming | |||
Excel :: Creating Entry Forms that auto load a workbook | Excel Programming |