Hlookup Macro
 

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.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=507753

Hlookup Macro
 

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