Excel VBA refering a control such as combo box
Posted: Wed Jan 03, 2018 1:44 pm
Just a little technical tip.
If you need to refer a control added to a sheet in Excel from code, make sure to insert an ActiveX rather than a form control. From controls could only be assigned to a macro. With ActiveX, you will be able to do almost everything you do with standard VB.
If you need to refer a control added to a sheet in Excel from code, make sure to insert an ActiveX rather than a form control. From controls could only be assigned to a macro. With ActiveX, you will be able to do almost everything you do with standard VB.