How do I chg the text size in my validation drop down box? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
  
 
 
 
tmeloff 12/18/2006 2:25 PM PST
  Question
  When I pull down the validation drop down box, the text selections are too
small to read. I've tried changing the font size in the source, and in the
box itself, but it doesn't affect the size of the text inside the selection
box.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Paul B 12/18/2006 2:43 PM PST
  Answer
  tmeloff, there is no way to do it from Excel, but have a look here for a
workaround

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> When I pull down the validation drop down box, the text selections are too
> small to read. I've tried changing the font size in the source, and in the
> box itself, but it doesn't affect the size of the text inside the
selection
> box.


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
tmeloff 12/22/2006 6:20 AM PST
   
  Thanks! I'll give it a try.

"Paul B" wrote:

> tmeloff, there is no way to do it from Excel, but have a look here for a
> workaround
>
> http://www.contextures.com/xlDataVal08.html#Font
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
> news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> > When I pull down the validation drop down box, the text selections are too
> > small to read. I've tried changing the font size in the source, and in the
> > box itself, but it doesn't affect the size of the text inside the
> selection
> > box.
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Florence 6/29/2009 11:55 PM PST
   
  I only have excel 2000 - is there anyway I can make my text size larger?

"tmeloff" wrote:

> Thanks! I'll give it a try.
>
> "Paul B" wrote:
>
> > tmeloff, there is no way to do it from Excel, but have a look here for a
> > workaround
> >
> > http://www.contextures.com/xlDataVal08.html#Font
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
> > news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> > > When I pull down the validation drop down box, the text selections are too
> > > small to read. I've tried changing the font size in the source, and in the
> > > box itself, but it doesn't affect the size of the text inside the
> > selection
> > > box.
> >
> >
> >
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Dave Peterson 6/30/2009 4:15 AM PST
   
  This suggestion will work in xl2k.

Did you have trouble when you tried it?

Florence wrote:
>
> I only have excel 2000 - is there anyway I can make my text size larger?
>
> "tmeloff" wrote:
>
> > Thanks! I'll give it a try.
> >
> > "Paul B" wrote:
> >
> > > tmeloff, there is no way to do it from Excel, but have a look here for a
> > > workaround
> > >
> > > http://www.contextures.com/xlDataVal08.html#Font
> > >
> > > --
> > > Paul B
> > > Always backup your data before trying something new
> > > Please post any response to the newsgroups so others can benefit from it
> > > Feedback on answers is always appreciated!
> > > Using Excel 2002 & 2003
> > >
> > > "tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
> > > news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> > > > When I pull down the validation drop down box, the text selections are too
> > > > small to read. I've tried changing the font size in the source, and in the
> > > > box itself, but it doesn't affect the size of the text inside the
> > > selection
> > > > box.
> > >
> > >
> > >

--

Dave Peterson
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Florence 6/30/2009 4:24 AM PST
   
  I followed the instructions to use a combo box but I couldn't change the
combo box properties.

"Dave Peterson" wrote:

> This suggestion will work in xl2k.
>
> Did you have trouble when you tried it?
>
> Florence wrote:
> >
> > I only have excel 2000 - is there anyway I can make my text size larger?
> >
> > "tmeloff" wrote:
> >
> > > Thanks! I'll give it a try.
> > >
> > > "Paul B" wrote:
> > >
> > > > tmeloff, there is no way to do it from Excel, but have a look here for a
> > > > workaround
> > > >
> > > > http://www.contextures.com/xlDataVal08.html#Font
> > > >
> > > > --
> > > > Paul B
> > > > Always backup your data before trying something new
> > > > Please post any response to the newsgroups so others can benefit from it
> > > > Feedback on answers is always appreciated!
> > > > Using Excel 2002 & 2003
> > > >
> > > > "tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
> > > > news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> > > > > When I pull down the validation drop down box, the text selections are too
> > > > > small to read. I've tried changing the font size in the source, and in the
> > > > > box itself, but it doesn't affect the size of the text inside the
> > > > selection
> > > > > box.
> > > >
> > > >
> > > >
>
> --
>
> Dave Peterson
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Dave Peterson 6/30/2009 6:39 AM PST
   
  What did you try?

Maybe you did something wrong.

Florence wrote:
>
> I followed the instructions to use a combo box but I couldn't change the
> combo box properties.
>
> "Dave Peterson" wrote:
>
> > This suggestion will work in xl2k.
> >
> > Did you have trouble when you tried it?
> >
> > Florence wrote:
> > >
> > > I only have excel 2000 - is there anyway I can make my text size larger?
> > >
> > > "tmeloff" wrote:
> > >
> > > > Thanks! I'll give it a try.
> > > >
> > > > "Paul B" wrote:
> > > >
> > > > > tmeloff, there is no way to do it from Excel, but have a look here for a
> > > > > workaround
> > > > >
> > > > > http://www.contextures.com/xlDataVal08.html#Font
> > > > >
> > > > > --
> > > > > Paul B
> > > > > Always backup your data before trying something new
> > > > > Please post any response to the newsgroups so others can benefit from it
> > > > > Feedback on answers is always appreciated!
> > > > > Using Excel 2002 & 2003
> > > > >
> > > > > "tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
> > > > > news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> > > > > > When I pull down the validation drop down box, the text selections are too
> > > > > > small to read. I've tried changing the font size in the source, and in the
> > > > > > box itself, but it doesn't affect the size of the text inside the
> > > > > selection
> > > > > > box.
> > > > >
> > > > >
> > > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Colin 7/23/2009 8:47 PM PST
   
  Hi,

I dont suppose anyone knows how I do this in 2007? the view-toolbars-control
toolbox steps just dont exist and the command converter doesnt have this in
it :(

"Dave Peterson" wrote:

> What did you try?
>
> Maybe you did something wrong.
>
> Florence wrote:
> >
> > I followed the instructions to use a combo box but I couldn't change the
> > combo box properties.
> >
> > "Dave Peterson" wrote:
> >
> > > This suggestion will work in xl2k.
> > >
> > > Did you have trouble when you tried it?
> > >
> > > Florence wrote:
> > > >
> > > > I only have excel 2000 - is there anyway I can make my text size larger?
> > > >
> > > > "tmeloff" wrote:
> > > >
> > > > > Thanks! I'll give it a try.
> > > > >
> > > > > "Paul B" wrote:
> > > > >
> > > > > > tmeloff, there is no way to do it from Excel, but have a look here for a
> > > > > > workaround
> > > > > >
> > > > > > http://www.contextures.com/xlDataVal08.html#Font
> > > > > >
> > > > > > --
> > > > > > Paul B
> > > > > > Always backup your data before trying something new
> > > > > > Please post any response to the newsgroups so others can benefit from it
> > > > > > Feedback on answers is always appreciated!
> > > > > > Using Excel 2002 & 2003
> > > > > >
> > > > > > "tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
> > > > > > news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> > > > > > > When I pull down the validation drop down box, the text selections are too
> > > > > > > small to read. I've tried changing the font size in the source, and in the
> > > > > > > box itself, but it doesn't affect the size of the text inside the
> > > > > > selection
> > > > > > > box.
> > > > > >
> > > > > >
> > > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Dave Peterson 7/24/2009 5:30 AM PST
   
  Show the Developer's tab
(You may have to turn it on under Office button|Excel Options)

You'll see an Insert Group.
Look for the Combobox and use that

(If that's the portion that you're asking about...)

Colin wrote:
>
> Hi,
>
> I dont suppose anyone knows how I do this in 2007? the view-toolbars-control
> toolbox steps just dont exist and the command converter doesnt have this in
> it :(
>
> "Dave Peterson" wrote:
>
> > What did you try?
> >
> > Maybe you did something wrong.
> >
> > Florence wrote:
> > >
> > > I followed the instructions to use a combo box but I couldn't change the
> > > combo box properties.
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > This suggestion will work in xl2k.
> > > >
> > > > Did you have trouble when you tried it?
> > > >
> > > > Florence wrote:
> > > > >
> > > > > I only have excel 2000 - is there anyway I can make my text size larger?
> > > > >
> > > > > "tmeloff" wrote:
> > > > >
> > > > > > Thanks! I'll give it a try.
> > > > > >
> > > > > > "Paul B" wrote:
> > > > > >
> > > > > > > tmeloff, there is no way to do it from Excel, but have a look here for a
> > > > > > > workaround
> > > > > > >
> > > > > > > http://www.contextures.com/xlDataVal08.html#Font
> > > > > > >
> > > > > > > --
> > > > > > > Paul B
> > > > > > > Always backup your data before trying something new
> > > > > > > Please post any response to the newsgroups so others can benefit from it
> > > > > > > Feedback on answers is always appreciated!
> > > > > > > Using Excel 2002 & 2003
> > > > > > >
> > > > > > > "tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
> > > > > > > news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> > > > > > > > When I pull down the validation drop down box, the text selections are too
> > > > > > > > small to read. I've tried changing the font size in the source, and in the
> > > > > > > > box itself, but it doesn't affect the size of the text inside the
> > > > > > > selection
> > > > > > > > box.
> > > > > > >
> > > > > > >
> > > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Sharon 7/24/2009 9:42 AM PST
   
  I am having the same problem as Colin 'the view-toolbars-control
toolbox steps just dont exist and the command converter doesnt have this in
it :( .' The Control Toolbox does not give me the Design, Properties icons
to switch views.


"Dave Peterson" wrote:

> Show the Developer's tab
> (You may have to turn it on under Office button|Excel Options)
>
> You'll see an Insert Group.
> Look for the Combobox and use that
>
> (If that's the portion that you're asking about...)
>
> Colin wrote:
> >
> > Hi,
> >
> > I dont suppose anyone knows how I do this in 2007? the view-toolbars-control
> > toolbox steps just dont exist and the command converter doesnt have this in
> > it :(
> >
> > "Dave Peterson" wrote:
> >
> > > What did you try?
> > >
> > > Maybe you did something wrong.
> > >
> > > Florence wrote:
> > > >
> > > > I followed the instructions to use a combo box but I couldn't change the
> > > > combo box properties.
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > This suggestion will work in xl2k.
> > > > >
> > > > > Did you have trouble when you tried it?
> > > > >
> > > > > Florence wrote:
> > > > > >
> > > > > > I only have excel 2000 - is there anyway I can make my text size larger?
> > > > > >
> > > > > > "tmeloff" wrote:
> > > > > >
> > > > > > > Thanks! I'll give it a try.
> > > > > > >
> > > > > > > "Paul B" wrote:
> > > > > > >
> > > > > > > > tmeloff, there is no way to do it from Excel, but have a look here for a
> > > > > > > > workaround
> > > > > > > >
> > > > > > > > http://www.contextures.com/xlDataVal08.html#Font
> > > > > > > >
> > > > > > > > --
> > > > > > > > Paul B
> > > > > > > > Always backup your data before trying something new
> > > > > > > > Please post any response to the newsgroups so others can benefit from it
> > > > > > > > Feedback on answers is always appreciated!
> > > > > > > > Using Excel 2002 & 2003
> > > > > > > >
> > > > > > > > "tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
> > > > > > > > news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> > > > > > > > > When I pull down the validation drop down box, the text selections are too
> > > > > > > > > small to read. I've tried changing the font size in the source, and in the
> > > > > > > > > box itself, but it doesn't affect the size of the text inside the
> > > > > > > > selection
> > > > > > > > > box.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > >
> > > > > --
> > > > >
> > > > > Dave Peterson
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Dave Peterson 7/24/2009 9:58 AM PST
   
  Did you show the developer's tab.

Did you look in the Insert Group?

Sharon wrote:
>
> I am having the same problem as Colin 'the view-toolbars-control
> toolbox steps just dont exist and the command converter doesnt have this in
> it :( .' The Control Toolbox does not give me the Design, Properties icons
> to switch views.
>
> "Dave Peterson" wrote:
>
> > Show the Developer's tab
> > (You may have to turn it on under Office button|Excel Options)
> >
> > You'll see an Insert Group.
> > Look for the Combobox and use that
> >
> > (If that's the portion that you're asking about...)
> >
> > Colin wrote:
> > >
> > > Hi,
> > >
> > > I dont suppose anyone knows how I do this in 2007? the view-toolbars-control
> > > toolbox steps just dont exist and the command converter doesnt have this in
> > > it :(
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > What did you try?
> > > >
> > > > Maybe you did something wrong.
> > > >
> > > > Florence wrote:
> > > > >
> > > > > I followed the instructions to use a combo box but I couldn't change the
> > > > > combo box properties.
> > > > >
> > > > > "Dave Peterson" wrote:
> > > > >
> > > > > > This suggestion will work in xl2k.
> > > > > >
> > > > > > Did you have trouble when you tried it?
> > > > > >
> > > > > > Florence wrote:
> > > > > > >
> > > > > > > I only have excel 2000 - is there anyway I can make my text size larger?
> > > > > > >
> > > > > > > "tmeloff" wrote:
> > > > > > >
> > > > > > > > Thanks! I'll give it a try.
> > > > > > > >
> > > > > > > > "Paul B" wrote:
> > > > > > > >
> > > > > > > > > tmeloff, there is no way to do it from Excel, but have a look here for a
> > > > > > > > > workaround
> > > > > > > > >
> > > > > > > > > http://www.contextures.com/xlDataVal08.html#Font
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > Paul B
> > > > > > > > > Always backup your data before trying something new
> > > > > > > > > Please post any response to the newsgroups so others can benefit from it
> > > > > > > > > Feedback on answers is always appreciated!
> > > > > > > > > Using Excel 2002 & 2003
> > > > > > > > >
> > > > > > > > > "tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
> > > > > > > > > news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> > > > > > > > > > When I pull down the validation drop down box, the text selections are too
> > > > > > > > > > small to read. I've tried changing the font size in the source, and in the
> > > > > > > > > > box itself, but it doesn't affect the size of the text inside the
> > > > > > > > > selection
> > > > > > > > > > box.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Dave Peterson
> > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Colin 7/26/2009 3:23 PM PST
   
  thanks muchly

"Dave Peterson" wrote:

> Show the Developer's tab
> (You may have to turn it on under Office button|Excel Options)
>
> You'll see an Insert Group.
> Look for the Combobox and use that
>
> (If that's the portion that you're asking about...)
>
> Colin wrote:
> >
> > Hi,
> >
> > I dont suppose anyone knows how I do this in 2007? the view-toolbars-control
> > toolbox steps just dont exist and the command converter doesnt have this in
> > it :(
> >
> > "Dave Peterson" wrote:
> >
> > > What did you try?
> > >
> > > Maybe you did something wrong.
> > >
> > > Florence wrote:
> > > >
> > > > I followed the instructions to use a combo box but I couldn't change the
> > > > combo box properties.
> > > >
> > > > "Dave Peterson" wrote:
> > > >
> > > > > This suggestion will work in xl2k.
> > > > >
> > > > > Did you have trouble when you tried it?
> > > > >
> > > > > Florence wrote:
> > > > > >
> > > > > > I only have excel 2000 - is there anyway I can make my text size larger?
> > > > > >
> > > > > > "tmeloff" wrote:
> > > > > >
> > > > > > > Thanks! I'll give it a try.
> > > > > > >
> > > > > > > "Paul B" wrote:
> > > > > > >
> > > > > > > > tmeloff, there is no way to do it from Excel, but have a look here for a
> > > > > > > > workaround
> > > > > > > >
> > > > > > > > http://www.contextures.com/xlDataVal08.html#Font
> > > > > > > >
> > > > > > > > --
> > > > > > > > Paul B
> > > > > > > > Always backup your data before trying something new
> > > > > > > > Please post any response to the newsgroups so others can benefit from it
> > > > > > > > Feedback on answers is always appreciated!
> > > > > > > > Using Excel 2002 & 2003
> > > > > > > >
> > > > > > > > "tmeloff" <tmeloff@discussions.microsoft.com> wrote in message
> > > > > > > > news:AADD70BD-85F4-4011-8905-C1EB7725916E@microsoft.com...
> > > > > > > > > When I pull down the validation drop down box, the text selections are too
> > > > > > > > > small to read. I've tried changing the font size in the source, and in the
> > > > > > > > > box itself, but it doesn't affect the size of the text inside the
> > > > > > > > selection
> > > > > > > > > box.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > >
> > > > > --
> > > > >
> > > > > Dave Peterson
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies