Basically I have an input/user sheet, an output sheet. The user makes a
selection from a listbox in the Input sheet, and I need what was
selected to be put in a cell in the Output sheet. Anyone know how to
do this? I've done this just doing cell to cell. That would be
"=input!A2" but I'm not sure how to do it for a listbox selection.
Thanks in advance.

Also, does anyone know how to get rid of the horizontal scrollbar that
automatically comes up with a listbox. Its not needed, and I cant
figure out how to get rid of it. Something about changing the "width"
under "properties" in the control toolbox.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/