Validation Text Too Small? Use a Userform!

A question was asked a few days ago about a dropdown validation list that was much too small to see.
It seemed to me there must be a way to display this (or any) validation list using a userform and in a much bigger font.

Find attached two examples that could accomplish this task.

The idea is that a userform needs to be created and the FONT of the control needs to be changed to a bigger and/or bolder size in that control's properties list.

Then I discovered that the range of a validation cell list is retrievable in code. This allows the same code to be used for any Validation List cell on a worksheet.

See the attached and double click on any of the validation cells in Columns A or B. Code will run to bring up a ComboBox in one attached file and a ListBox in the other attached file. When you click on the desired selection it will put it in the active cell.

Look behind the sheet for the event code that triggers only if the validation cell is a type of List. Then look at the userform code and mostly the properties of the combobox or listbox Font.

I hope this little tool will help others to see what they are selecting in a Validation list.

Bump Once!

Hi Marvin,
yeap, I tried it few minutes ago and it works fain. before I used zoom to make it bigger.
thank you!

This may be of interest to you
http://www.contextures.com/xlDataVal10.html

Hi Andy,

Yes, your link above ties a combo box onto the validation list range of cells. I had fun poking around the Object Browser and typing things into the immediate window to discover what was allowed and what it meant.

Excel does so many things, as you know, because of your fame with graphs that us experts are still learning. Thanks for the link above. I hope it solves this problem of "Validation text, too small" for users of the site.