Excel ActiveX Listbox not enabled on file open Excel ActiveX Listbox not enabled on file open vba vba

Excel ActiveX Listbox not enabled on file open


Siddharth Rout provided the answer in a comment. After you have populated the listbox, right at the end (just before end sub) activate sheet2 and in the next line activate the launch sheet. Use Application.Screenupdating =false to ensure that there is no screen flickering.