Automatically scroll when navigating controls Using TAB key

Hi All,

I have several various VBA controls on a sheet that the user may
navigate to and from by using TAB key ('tabbing' from one control
to the next by using the KeyDown() Function of the control)

However once the user tabs to a control that is not visible on the sheet,
they would have to manually scroll down the page to notice that they
have tabbed to the next control. That is, excel won't follow (or make visible)
the control that is currently active.

Any thoughts on how to automate this (rather than have the user manually scroll) would be greatly appreciated!

Best

Hi mstasko1990;

You can use the control's "TopLeftCell" property, and Window.scrollrow property to make it visible.