| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data validation 'snippets'
Hello again -
My question is this- I would like a drop-down in the box to say "Red, Yellow, Blue" but then I would like the text in the box to be "R, Y or B". Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data validation 'snippets'
"Katie" wrote:
I would like a drop-down in the box to say "Red, Yellow, Blue" but then I would like the text in the box to be "R, Y or B". Is this possible? One play to achieve it would be to use a combo box from the control toolbox toolbar Try this sample from my archives which illustrates: http://savefile.com/files/221672 Combo box from control toolbox toolbar_Example2.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data validation 'snippets'
Max,
Thanks for your super-quick response! I downloaded/printed/adapted your instructions to work with my sheet. I still cannot make it work perfectly, even though I have put letter codes in the "codes" column, it interprets those as numbers and gives me the number of the choice I've selected. Also, when I go to properties in the format combo-box section, it does not have bound column, column count or column widths. Lastly, Is there any way to make the box disappear after the selection is made so that you can see the choice if it's right on top of it? "Max" wrote: "Katie" wrote: I would like a drop-down in the box to say "Red, Yellow, Blue" but then I would like the text in the box to be "R, Y or B". Is this possible? One play to achieve it would be to use a combo box from the control toolbox toolbar Try this sample from my archives which illustrates: http://savefile.com/files/221672 Combo box from control toolbox toolbar_Example2.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data validation 'snippets'
I'm a moron. I was using the forms combo box. Thank you.
"Katie" wrote: Max, Thanks for your super-quick response! I downloaded/printed/adapted your instructions to work with my sheet. I still cannot make it work perfectly, even though I have put letter codes in the "codes" column, it interprets those as numbers and gives me the number of the choice I've selected. Also, when I go to properties in the format combo-box section, it does not have bound column, column count or column widths. Lastly, Is there any way to make the box disappear after the selection is made so that you can see the choice if it's right on top of it? "Max" wrote: "Katie" wrote: I would like a drop-down in the box to say "Red, Yellow, Blue" but then I would like the text in the box to be "R, Y or B". Is this possible? One play to achieve it would be to use a combo box from the control toolbox toolbar Try this sample from my archives which illustrates: http://savefile.com/files/221672 Combo box from control toolbox toolbar_Example2.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data validation 'snippets'
"Katie" wrote
.. I was using the forms combo box. Thank you. Glad you got it up there <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data validation 'snippets'
Max-
My last question- I promise. :-) I have it working fine now, but the options in the drop-down are smushed together. Could you help me determine how to alter the size of the drop-down? "Max" wrote: "Katie" wrote .. I was using the forms combo box. Thank you. Glad you got it up there <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data validation 'snippets'
Try tinkering with the Font / Font style / Size in "Properties"
Click inside the font line, then click on the little dotted gray box to open the Font dialog (I used Gill Sans MT Regular 8) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Katie" wrote: Max- My last question- I promise. :-) I have it working fine now, but the options in the drop-down are smushed together. Could you help me determine how to alter the size of the drop-down? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data validation 'snippets'
You're my hero. Thanks Max!
"Max" wrote: Try tinkering with the Font / Font style / Size in "Properties" Click inside the font line, then click on the little dotted gray box to open the Font dialog (I used Gill Sans MT Regular 8) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Katie" wrote: Max- My last question- I promise. :-) I have it working fine now, but the options in the drop-down are smushed together. Could you help me determine how to alter the size of the drop-down? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data validation 'snippets'
Welcome, Katie.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Katie" wrote in message ... You're my hero. Thanks Max! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Refresh existing data when changed in data validation list | New Users to Excel | |||
Linear Mode
