| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Listbox Values
I have created a listbox with the days of the week in Excel 2003, however,
when I click on say Tuesday I get the number 2 as opposed to the word Tuesday. Is there any way for me to set it so that it displays my selection rather than its position in the list? I'm using the Forms Toolbar and not Data Validation. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listbox Values
Is there any way to set it so that it displays my selection
rather than its position in the list? Use the listbox from the control toolbox instead. It'll do just that. After you draw it (ie a listbox) out on the sheet, right-click on it Properties, then set ListFillRange & LinkedCell, eg: ListFillRange: A1:A7 (assume that's where you have: Mon, Tues, etc) LinkedCell: B1 Click "Exit Design Mode", try it out (ListFillRange & LinkedCell are equivalent to "Input range" & "Cell link") -- Max Singapore http://savefile.com/projects/236895 Downloads:16,200 Files:354 Subscribers:53 xdemechanik --- "Richard" wrote: I have created a listbox with the days of the week in Excel 2003, however, when I click on say Tuesday I get the number 2 as opposed to the word Tuesday. Is there any way for me to set it so that it displays my selection rather than its position in the list? I'm using the Forms Toolbar and not Data Validation. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listbox Values
That Worked. Thanks!
"Max" wrote: Is there any way to set it so that it displays my selection rather than its position in the list? Use the listbox from the control toolbox instead. It'll do just that. After you draw it (ie a listbox) out on the sheet, right-click on it Properties, then set ListFillRange & LinkedCell, eg: ListFillRange: A1:A7 (assume that's where you have: Mon, Tues, etc) LinkedCell: B1 Click "Exit Design Mode", try it out (ListFillRange & LinkedCell are equivalent to "Input range" & "Cell link") -- Max Singapore http://savefile.com/projects/236895 Downloads:16,200 Files:354 Subscribers:53 xdemechanik --- "Richard" wrote: I have created a listbox with the days of the week in Excel 2003, however, when I click on say Tuesday I get the number 2 as opposed to the word Tuesday. Is there any way for me to set it so that it displays my selection rather than its position in the list? I'm using the Forms Toolbar and not Data Validation. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listbox Values
Welcome. Do take a moment to press the "Yes" button below, from where you're
reading this. -- Max Singapore http://savefile.com/projects/236895 Downloads:16,300 Files:356 Subscribers:53 xdemechanik --- "Richard" wrote: That Worked. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i set up a dropdown listbox of values in a column of cells | Excel Worksheet Functions | |||
| Listbox 2 takes the value of Listbox 1 | Excel Discussion (Misc queries) | |||
| ListBox with Horizontal Values | Excel Worksheet Functions | |||
| listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
| MSOffice Excel 2003-Validation Listbox takes only 47 values | Excel Worksheet Functions | |||
Linear Mode
