How do I use activex controls in excel vba?



How do I use activex controls in excel vba?..

Answer / Ahsan Khan

To use ActiveX controls in Excel VBA, you first need to insert the control on your worksheet by clicking 'Developer' tab > 'Insert' > 'ActiveX Control'. After that, you can access it from VBA code using its object name. Here is an example:nnDim myControl As ObjectnSet myControl = ActiveSheet.OLEObjects("Name of your control").Object

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ActiveX Interview Questions

What does activex control do?

1 Answers  


What browser supports activex?

1 Answers  


How do I turn off activex?

1 Answers  


What does activex filtering do?

1 Answers  


What is activex control in ie?

1 Answers  


What is activex control in internet explorer?

1 Answers  


How do I add an activex control in excel?

1 Answers  


What are the properties exposed by ActiveX controls?

2 Answers  


How do I unregister an ocx file?

1 Answers  


What is activex filtering?

1 Answers  


What is activex control in vb net?

1 Answers  


How do I register comctl32 ocx?

1 Answers  


Categories