Find value in range
Hi all,
I'm looking for an efficient way to find the row in a sheet with a matching
value in column A to a textbox value on a userform.
The userform is used to gather record information from the user and update
the spreadsheet. The spreadsheet can accumulate upwards of 100+ records and
the user form is the only way to navigate the data - I need a way to "jump"
to a specific record. The txtActivityNo would be the unique record identifier.
help?
|