form listbox help

[d0wnt0wn]

hi is there any way that if i select an item from a listbox made with the forms control that i can have that selection appear in a cell?

i need this to be a forms listbox and not a control listbox

 

[HalfAce]

Hello d0wnt0wn,
Yes. Right click the listbox & choose Format control and then the Control tab.
Enter the cell you want the selection to go to in the Cell link field.

Be aware though, that by using a Forms listbox (as opposed to the Controls Toolbox listbox) all you'll get in your linked cell is the index number of the selection. (ie, choose the third item, you'll get a 3 in the linked cell, not the text (or number) that you selected.)

Hope it helps.

 

[d0wnt0wn]

hi half ace..... thanks for the reply.... yes I already use that option because its linked to an xy scatter chart...... can i use more than 1 cell to reference???? because that might work if i use the numbers and a vlookup

 

[HalfAce]

Not sure if I understand, but as far as I know you can't have two linked cells to it, if that's what you're asking, but you can use a simple ( = A1 ) type formula to run your vlookups from, or even just use the linked cell for that.