S
Sean
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
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