Hlookup Macro

[comotoman]

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

[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