Macro for scrolling

boydr · May 19th, 2002, 10:34 PM

Hello,

Is there a way to create a macro that will scroll to the far left after I enter data in a certain cell and then hit tab? If I scroll right and enter information is a cell and hit tab, it may go back to (for example) C2 and not show the values in A2 and B2. I want the macro to scroll all the way left after I hit tab in cell K2? Any suggestings?
The cell would always be constant, and I actually have 3 different cells that I want this for.

Juan Pablo González · May 19th, 2002, 11:20 PM

You can use a macro in the SelectionChange event of the sheet, or you can set the Sheet's scrollarea to "limit" it to your area (A:K)...

May 19th, 2002, 11:20 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	You can use a macro in the SelectionChange event of the sheet, or you can set the Sheet's scrollarea to "limit" it to your area (A:K)... __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 19th, 2002, 10:34 PM	#1
boydr Board Regular Join Date: Apr 2002 Location: Arkansas Posts: 157	Hello, Is there a way to create a macro that will scroll to the far left after I enter data in a certain cell and then hit tab? If I scroll right and enter information is a cell and hit tab, it may go back to (for example) C2 and not show the values in A2 and B2. I want the macro to scroll all the way left after I hit tab in cell K2? Any suggestings? The cell would always be constant, and I actually have 3 different cells that I want this for.