Hlookup Macro

C

comotoman

Current formula is > "=HLOOKUP(B2,A45:D50,*2*,FALSE)" Need help with
macro to change row_index_number by + or - 1. It is for a "Next" an
"Prev" Command Button
 
V

vezerid

You can use a scrollbar ActiveX control (Tools|Customize...|Toolbars,
check the Forms toolbar).

Draw the scrollbar on the sheet, double-click to format and set a Cell
LInk. Then your HLOOKUP() can tak 3rd argument from the cell.

HTH
Kostis Vezerides
 
Top