ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Validation problem (https://www.excelbanter.com/excel-programming/312740-validation-problem.html)

GMet

Validation problem
 
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



Frank Kabel

Validation problem
 
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




Norman Jones

Validation problem
 
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





Norman Jones

Validation problem
 
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








All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com