developer drop down font

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Developer, drop down font size

Developer, drop down font size

resolvedResolved · Urgent Priority · Version 2016

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

Thu 31 May 2018: Automatically marked as resolved.


 

Excel tip:

Auto-insert the current time

In Microsoft Excel, to enter the current time into a cell, hold CTRL+SHIFT and press SEMICOLON.

View all Excel hints and tips


Server loaded in 0.07 secs.