How to change font size in Drop Down Menu.

[nevernine9]

Hello Friends!
How Do I change font size (want bigger font) in DropDown Menu. ?

DropDown_Font_Change_Help.png

I would appreciate any help anyone can provide !!

[MarvinP]

Hi nevernine,

If you are using a Validation Dropdown Box, then you are stuck with the font size it gives. If you want to use a ComboBox then you can go wild.

http://www.contextures.com/xlDataVal10.html

Note the first sentence of the above site are:
To overcome the limitations of a data validation drop down list..

[Root_]

If you are developing a new worksheet, set zoom to, say, 150% and font size to, say, 8 from the start -- then your dropdowns will be more eye-friendly.

[nevernine9]

Hi Friends,
I did change "DropDown Validation Box" to "ComboBox".
but when I choose values form list, it gives me error on LinkedCell - "Numbered Stored as Text".
It gives me result when I click "convert to number". But I have to change this every time.

Numbered Stored As TEXT_Help.png

Can not attach file on ExcelForum, so upload it on

OneDrive : https://1drv.ms/x/s!ApvA7yM1kwXlgwdxYxe6uifswGCP

Google Drive : https://drive.google.com/open?id=0B4...mxwTGVlSEFUMGc

Thanks

[MarvinP]

Hi,

It looks like you have a bad formula in D7 that I couldn't get past. What is your question after using a ComboBox now? Did you follow the instructions on the link I provided above?

[nevernine9]

After I changed to Combobox, I get above error when I choose value from list.

[MarvinP]

I got errors also and that is why we need a sample workbook to work through the problem.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[nevernine9]

Here is an attachment. I don't have Before file.

Thanks

[nevernine9]

Please Help on this ..
Thanks