Format the visible text (size,font etc) in a drop down box?

ajmckenna

Board Regular
Joined
Oct 7, 2002
Messages
145
Anybody know how to do this? my drop down box list is very small and hard to see

thanks
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

ajmckenna

Board Regular
Joined
Oct 7, 2002
Messages
145
Anyone? I use drop down box (an the value it sends to its linked cell) to run macros.
 

Bruno

Active Member
Joined
Feb 17, 2002
Messages
491
Maybe a work around ?
Use an userform with your drop-down list...
 

Chas17

Well-known Member
Joined
Oct 16, 2002
Messages
657
I assumed you were using the drop down combo box from the Forms toolbar. Suggest you try the drop down combo box from the Control toolbox toolbar. You will have to make your macro run from the event, but you can set the properties of the dropdown for font size. If you have not used this before learn about design mode.
 

ajmckenna

Board Regular
Joined
Oct 7, 2002
Messages
145
I figured out that combo box from control toll bar will work, but it is very very slow when choosing a selection in drop down menu as well as when Iam setting up the properties. why is that?
Am I better off using data validation? I.e I can format the cell that the validation is in. and how do I link a macro to run when value of the cell containing data validation is changed.

thanks
 

Bruno

Active Member
Joined
Feb 17, 2002
Messages
491
If your list is not toooo looong :wink:
let's say 30 items max. use data validation.
 

Forum statistics

Threads
1,144,059
Messages
5,722,272
Members
422,419
Latest member
Havok390

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top