Listbox highlighting selected item in worksheet

**Shellybelly** · 03-16-2015, 08:02 PM

Can anyone help me with a code that will highlight selected item in a listbox on a worksheet?

I have a listbox that searches for an employee name through out the entire workbook and populates the worksheet names where the employee resides.

eg Andall Henry Sheet 1
Andall Henry Sheet 2

I want a code that will highlight the row in the specified sheet andall's name resides when select either Andall Henry sheet 1 or Andall Henry Shee2

Can anyone help me?

**protonLeah** · 03-16-2015, 09:10 PM

Attach a Workbook
(please do not post pictures or links to worksheets)

Click Advanced (next to quick post),
Scroll down until you see "Manage Attachments",
Click that then select "add files" (top right corner).
Click "Select Files" find your file, click "open" click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Click "Done" at bottom right to close the Attachment Manager.
Click "Submit Reply"