Listbox Values

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

 

[Max]

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]

That Worked. Thanks!

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

 

[Max]

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