Developer, drop down font size

Hi Askhat,

Yes you can.

In the design view double click the ActiveX control. This will bring you to the private module for your ActiveX controls. You can call a macro or write your code inside the Click event.

See below:






Private Sub CommandButton1_Click()
Call NameOfMacro
End Sub

Private Sub CommandButton1_Click()
Write the code here
End Sub


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector