Hi,
I have a macro file here (attached in this thread) where it contains the 'Generate' button, 'Clear' button and an ActiveX Combo box.
The source data for the combo box is pulling from the SQL database.
Each time when I open the macro file, the combo box does not show any results. I need to enable the Developer tab from the Excel ribbon > enter Design mode > double-click on the combo box to bring up the VBA code screen > Run Sub/UserForm (F5) in order to refresh the data set. After doing this sequence, the data will appear in the ActiveX Combo box.
Is there any way to automatically display the data inside ActiveX Combo box once the macro file is opened?
Appreciate if anyone can assist. Thanks
Bookmarks