I want to use the validation feature to input data into a field. The
problem is that I can't get the validation font size to match the cell font
size. The cell font is 24 but the validation seems to be about 6. Is there
a way I can make them the same?

GMet

Hi
you can't change the font size in the data validation listbox depending
on your data source cells

--
Regards
Frank Kabel
Frankfurt, Germany

"GMet" schrieb im Newsbeitrag
...
I want to use the validation feature to input data into a field. The
problem is that I can't get the validation font size to match the
cell font
size. The cell font is 24 but the validation seems to be about 6.
Is there
a way I can make them the same?

GMet

Hi Gmet,

You cannot change the validation list fontsize but see Debra Dalgleish's
site for a possible workaround:

Data Validation Font Size and List Length


---
Regards,
Norman



"GMet" wrote in message
...
I want to use the validation feature to input data into a field. The
problem is that I can't get the validation font size to match the cell
font
size. The cell font is 24 but the validation seems to be about 6. Is
there
a way I can make them the same?

GMet

Hi GMet,

That link should be:

http://www.contextures.com/xlDataVal08.html - Font


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Gmet,

You cannot change the validation list fontsize but see Debra Dalgleish's
site for a possible workaround:

Data Validation Font Size and List Length


---
Regards,
Norman



"GMet" wrote in message
...
I want to use the validation feature to input data into a field. The
problem is that I can't get the validation font size to match the cell
font
size. The cell font is 24 but the validation seems to be about 6. Is
there
a way I can make them the same?

GMet