Hello all!
I have a few ActiveX combo boxes that don't work unless I open the VBA and click "Run". After I do that, they work fine until I close the workbook. Any thoughts on how I might get these to work all of the time?
I have other ActiveX command buttons in the same workbook that use a "click" code in VBA and they work every as soon as I open the workbook without opening VBA.
I tried both the "click" and "change" commands below.
Any ideas about what might be happening are appreciated!
Thanks!
I have a few ActiveX combo boxes that don't work unless I open the VBA and click "Run". After I do that, they work fine until I close the workbook. Any thoughts on how I might get these to work all of the time?
I have other ActiveX command buttons in the same workbook that use a "click" code in VBA and they work every as soon as I open the workbook without opening VBA.
I tried both the "click" and "change" commands below.
VBA Code:
Private Sub CB_ST_GRA_Change()
CB_ST_STA.Clear
CB_ST_GRA.List = Array("Kindergarten", "1st Grade", "2nd Grade", "3rd Grade", "4th Grade", "5th Grade", "6th Grade", "7th Grade", "8th Grade", "9th Grade", "10th Grade", "11th Grade", "12th Grade")
End Sub
Sub CB_ST_GRA_click()
CB_ST_STA.Clear
CB_ST_GRA.List = Array("Kindergarten", "1st Grade", "2nd Grade", "3rd Grade", "4th Grade", "5th Grade", "6th Grade", "7th Grade", "8th Grade", "9th Grade", "10th Grade", "11th Grade", "12th Grade")
End Sub
Any ideas about what might be happening are appreciated!
Thanks!