#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
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
How do i set up a dropdown listbox of values in a column of cells TheRulie Excel Worksheet Functions 2 May 31st 07 12:38 PM
Listbox 2 takes the value of Listbox 1 Illya Teideman Excel Discussion (Misc queries) 3 April 10th 07 03:20 PM
ListBox with Horizontal Values Scott Halper Excel Worksheet Functions 1 March 27th 07 12:20 AM
listbox B conditional of input in Listbox A Kim K Excel Discussion (Misc queries) 1 October 31st 06 08:27 PM
MSOffice Excel 2003-Validation Listbox takes only 47 values Keryun Excel Worksheet Functions 4 February 2nd 06 06:02 PM


All times are GMT +1. The time now is 02:29 PM.

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

About Us

"It's about Microsoft Excel"