Excel VBA refering a control such as combo box

Visual Basic Topics
Post Reply
User avatar
SevenZero
Posts: 276
Joined: Sun Nov 01, 2009 8:37 pm

Excel VBA refering a control such as combo box

Post by SevenZero » 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.
Post Reply

Return to “Visual Basic Programming”