issue populating combox options from vba

Why wouldn't this be working? i have a sheet called yer maw and one ComboBox1. i write the following code to "ThisWorkbook", save and close. Book opens without any errors, but my combobox contains nothing!! what am i doing wrong?

Private Sub Workbook_Open()


With ActiveWorkbook.Worksheets("yer maw").ComboBox1
    .Clear
    .AddItem "All Decks"
    .AddItem "maw 1"
    .AddItem "ma maw 2"
    .AddItem "his maw 3"
    .AddItem "Deck 4"
    .AddItem "Deck rrr"
End With
End Sub

Your syntax is wrong. Depending on the type of combobox it would be one of the two:

Sub Example1()

'ActiveX
With ActiveWorkbook.Worksheets("yer maw").OLEObjects("ComboBox1").Object
    .Clear
    .AddItem "All Decks"
    .AddItem "maw 1"
    .AddItem "ma maw 2"
    .AddItem "his maw 3"
    .AddItem "Deck 4"
    .AddItem "Deck rrr"
End With

'Form Control
With ActiveWorkbook.Worksheets("yer maw").Shapes("Drop Down 1").ControlFormat
    .RemoveAllItems
    .AddItem "All Decks"
    .AddItem "maw 1"
    .AddItem "ma maw 2"
    .AddItem "his maw 3"
    .AddItem "Deck 4"
    .AddItem "Deck rrr"
End With

End Sub

hi, your activex example works when i place in the body of my main code in module9 and use another button to write to it, but for some reason it will not be written to if place the code within "thisworkbook" any further ideas?

thanks

This works just fine for me when tested in "thisworkbook"

Private Sub Workbook_Open()

With Worksheets("yer maw").OLEObjects("ComboBox1").Object
    .Clear
    .AddItem "All Decks"
    .AddItem "maw 1"
    .AddItem "ma maw 2"
    .AddItem "his maw 3"
    .AddItem "Deck 4"
    .AddItem "Deck rrr"
End With

End Sub

I got it to work, i tihnk it was probably always working! not sure if this is normal behavior or not, but it only works (including yours) if i close down excel completely.

opening the .xlsm from a running instance of excel with NO workbooks open, i.e. File > Open etc, did not fire the open workbook event

opening the .xlsm from a windows directory without any instance of excel running DID fire the open workbook event


is this normal?

gave up, .clear wasnt working either! so i went with the form-control version which works perfectly. Possibly some work IT security settings for Active x or something blocking it.