Changin Font In Data Validation List

Mar 12th, 2002, 04:39 AM

Just a quickie. Is it possible to change the font type and size that is displayed in a data validation dropdown list? I want to use Wingdings characters but even though I have default font set to Wingdings and the actual cell set to Wingdings, the dropdown still appears in Arial?

I'm using Excel 97 by hte way.

Dave Hawley · Mar 12th, 2002, 04:44 AM

Hi

As far as I am aware the answer is no! But you never know.

Mr Nick · Mar 13th, 2002, 05:12 AM

Can anybody confirm for definate whether or not this is possible?

Audiojoe · Mar 13th, 2002, 05:17 AM

I've tried doing it loads of times and have looked into it a lot, but I've never found any evidence to say you can, but then again, I never thought Tom Cruise and Nicole Kidman were going to split up

If you use a VBA combobox you can though, but that's not even remotely useful now is it

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 04:39 AM	#1
Guest Posts: n/a	Just a quickie. Is it possible to change the font type and size that is displayed in a data validation dropdown list? I want to use Wingdings characters but even though I have default font set to Wingdings and the actual cell set to Wingdings, the dropdown still appears in Arial? I'm using Excel 97 by hte way.

Mar 12th, 2002, 04:44 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi As far as I am aware the answer is no! But you never know.

Mar 13th, 2002, 05:12 AM	#3
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	Can anybody confirm for definate whether or not this is possible?

Mar 13th, 2002, 05:17 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	I've tried doing it loads of times and have looked into it a lot, but I've never found any evidence to say you can, but then again, I never thought Tom Cruise and Nicole Kidman were going to split up If you use a VBA combobox you can though, but that's not even remotely useful now is it