Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How do I chg the text size in my validation drop down box?

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 709
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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.




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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.




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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


  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 86
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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

  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 183
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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



  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 86
Default How do I chg the text size in my validation drop down box?

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" wrote in message
...
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
merged cells into one text cell, size varies dependant on text dat Jazzylady825 Excel Discussion (Misc queries) 0 December 9th 05 08:26 PM
Text size in validation drop-down list box Jon Excel Worksheet Functions 1 October 11th 05 08:20 PM
validation list drop down box, how do I bring in text commands Scott Excel Discussion (Misc queries) 1 September 29th 05 04:01 PM
drop downs & data validation burgi Excel Discussion (Misc queries) 2 June 23rd 05 09:40 PM
Text to Columns from drop down list update Kurgan Excel Discussion (Misc queries) 0 June 21st 05 12:14 PM


All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"