close
Current formula is gt; quot;=HLOOKUP(B2,A4550,*2*,FALSE)quot; Need help with a
macro to change row_index_number by or - 1. It is for a quot;Nextquot; and
quot;Prevquot; Command Button.--
comotoman
------------------------------------------------------------------------
comotoman's Profile: www.excelforum.com/member.php...oamp;userid=27292
View this thread: www.excelforum.com/showthread...hreadid=507753You 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
全站熱搜
留言列表
