search
 

Hello All,

I would like to go to a sheet, find a cell that has the
same value (either a name or number) as a text box in a
userform.

Once the value is found, I need to identify what is in
the cells (in the same row) on either side of it.

I can only do this, with my juvinile programming
abilities, by going to the sheet, selecting a particular
column and looking at every cell.

I would ultimately like to perform this on a hidden
worksheet.

Thanks in advance