Then you will have to go the Combo-box route.
Did you check out Debra's site?
I'll direct you to another of her pages which shows how to use a Combo-box.
Note:VBA coding required with this method.
http://www.contextures.on.ca/xlDataVal10.html
Gord Dibben MS Excel MVP
On Mon, 10 Jul 2006 15:04:01 -0700, Mindie <Mindie[ at ]discussions.microsoft.com>
wrote:
[Quoted Text] >Yes it is Data Validation. Problem is that I do not want to change the whole >sheet, just what is in the drop-down list. > >"Gord Dibben" wrote: > >> Mindie >> >> What type of drop-down list? >> >> Data Validation? Font size cannot be changed although you can use Zoom to >> make the whole sheet larger. >> >> See Debra Dalgleish's site for workarounds. >> >> http://www.contextures.on.ca/xlDataVal08.html#Font>> >> >> Gord Dibben MS Excel MVP >> >> On Mon, 10 Jul 2006 12:40:02 -0700, Mindie <Mindie[ at ]discussions.microsoft.com> >> wrote: >> >> >I have a drop down list where I want to change the Font Size. I have tried >> >changed it in the cells where the data resides and also in the cells where >> >you have the drop down list and neither way increase the Font Size. I am >> >sure it is something very simple that I am forgetting. Hope someone has the >> >answer. >> >>
|