Listbox Values

R

Richard

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.
 
M

Max

Is there any way to set it so that it displays my selection
rather than its position in the list?
Click to expand...

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
---
 
R

Richard

That Worked. Thanks!

Max said:
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
Click to expand...
 
Top