| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
jumping to a cell which matches user specified text
hi, i have a list of parts in a sheet. i want the user to be able to enter a part number (this will be unique) then excell to move to the row which holds that part number. basically what the built in goto function does in the edit menu. basically... user runs macro... input box enter the part number..... searches for that part number...... moves to the row which holds that part number. thanks in advance matthew ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cursor jumping to next cell | Excel Discussion (Misc queries) | |||
| JUMPING TO THE NEAREST FORMULA CONTAINING CELL | Excel Discussion (Misc queries) | |||
| Jumping reference cell in dependent cell formula | Excel Worksheet Functions | |||
| Jumping to a certain cell | Excel Discussion (Misc queries) | |||
| Jumping to the next cell automaticly | Excel Discussion (Misc queries) | |||
Threaded Mode
