Ok guys and gals! I have some VB code that I'm about to post, hope I don't get into trouble for posting this by my boss but I need major help! So here goes. I need this To work every time I open the spreadsheet. Here is the code can someone help in finding a way for it to automatically run?
[CODE=vb]Private Sub ComboBox1_open( )
ComboBox1.Clear
ComboBox1.AddIt em ...
ComboBox1.AddIt em ...
...
End Sub
Private Sub ComboBox1_Chang e()
Select Case ComboBox1.Value
Case ...
Cells(5, 4).Value = "..."
Cells(5, 5).Value = "..."
...
End Select
End Sub[/CODE]
Please I need this done by the end of the week. Thank you in advanced!
[CODE=vb]Private Sub ComboBox1_open( )
ComboBox1.Clear
ComboBox1.AddIt em ...
ComboBox1.AddIt em ...
...
End Sub
Private Sub ComboBox1_Chang e()
Select Case ComboBox1.Value
Case ...
Cells(5, 4).Value = "..."
Cells(5, 5).Value = "..."
...
End Select
End Sub[/CODE]
Please I need this done by the end of the week. Thank you in advanced!
Comment