Connecting Tech Pros Worldwide Forums | Help | Site Map

EXCEL listbox: carrying selected value over to amother worksheet

Newbie
 
Join Date: Oct 2006
Location: michigan, U.S.A.
Posts: 24
#1: Jan 12 '07
Hello,

I am wondering how to "carry over" a value from a listbox on one worksheet in the workbook to a cell in another worksheet in the same workbook.

For example, to just copy over a value from a textbox (as opposed to a listbox), this code in the destination cell does the trick:

='Source Worksheet Name'!E21

where E21 is the cell in the source (origin) worksheet that has the data. With a listbox in the source worksheet, I see the integer of the value selected. It would say 1 if someone selected the first item (apparently it doesn't start with zero like an array does). How do I decode the integer to get the text value in the destination cell? Is there a simple Excel trick or should I use visual basic to do it?
Thanks you in advance.

Newbie
 
Join Date: Oct 2006
Location: michigan, U.S.A.
Posts: 24
#2: Jan 13 '07

re: EXCEL listbox: carrying selected value over to amother worksheet


No worries, I figured it out. Thanks anyway.
Reply