VB help with Autorun of spreadsheet

[bg0420]

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?

Private Sub ComboBox1_open()
ComboBox1.Clear
ComboBox1.AddItem ...
ComboBox1.AddItem ...
...
End Sub
 
Private Sub ComboBox1_Change()
Select Case ComboBox1.Value
 
  Case ...
    Cells(5, 4).Value = "..."
    Cells(5, 5).Value = "..."
    ...
End Select
 
End Sub

Please I need this done by the end of the week. Thank you in advanced!

[Killer42]

You could try putting it (or better, putting a call to it) in the Workbook_Open event.

[bg0420]

You could try putting it (or better, putting a call to it) in the Workbook_Open event.

Just done it and all it did was put a date in with no working combo box.

[Killer42]

Just done it and all it did was put a date in with no working combo box.

You just asked how to get it ro run automatically. Are you saying there are further problems with the code?

[bg0420]

You just asked how to get it ro run automatically. Are you saying there are further problems with the code?

I'm guessing so. I have posted the code into the VB under Sheet1 and I have to manually go into the VB by pressing F11 then I have to put my cursor next to the end sub and press F5. I'm not understanding of why I have to do that every time I open the spreadsheet up.

[Killer42]

Well, I don't know, but whatever you put in the Workbook_Open event should run automatically when the workbook is opened.

[bg0420]

Well, I don't know, but whatever you put in the Workbook_Open event should run automatically when the workbook is opened.

I just hit another problem, I added another Combobox and put a bunch of code into it and it said it's to big. I guess I'm screwed.

[Killer42]

I just hit another problem, I added another Combobox and put a bunch of code into it and it said it's to big. I guess I'm screwed.

What said that what is too big?