Askhat has attended:
Excel Forecasting and Data Analysis course
Developer, drop down font size
Hello,
Can you please advise, how I can change font size(text size) of drop down and option buttons? there is no font change in properties.
Thanks
RE: developer, drop down font size
Hi Askhat,
Thank you for the forum question.
You can only change the font size if you use ActiveX controls.
The ActiveX controls can be coded to change the font size.
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
RE: developer, drop down font size
Jens, thank you!
i need one more help.
i changed option buttons for activex controls, but i couldn't assign macro for this option button.
before i could assign macro for option button, but it was just form control.
please advise
Askhat
RE: developer, drop down font size
Hi Askhat,
To code ActiveX controls you will need to be in design view and then double click the control. This will bring you to the private model for the ActiveX controls.
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
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
RE: developer, drop down font size
hello Jens,
the question is again about option buttons in activex controls. can i assign macro for this button?
thanks,
Askhat
RE: 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
RE: developer, drop down font size
Thank you Jens,
it works.
RE: developer, drop down font size
Great I am happy to help.
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
