View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
#DIV/0 #DIV/0 is offline
external usenet poster
 
Posts: 30
Default display more info for listbox entry

Hi,
I have a database on a worksheet and a userform to search one column for a
text string that the user puts in a textbox. The listbox shows just the
filtered cells.
I'd like the user to be able to select an item in the listbox and view
further info for that item (ie the values of other cells in the same row).
I'd put them as the caption of a label or some other "untouchable" way.
For example the text search looks in the product decription (column B) and
I'd like the user to see the product code (column A) and warehouse
availability (Column E).

--
David M