I have a VAB Application in Excel. Excel worksheet has some controls (check boxes, comboboxes, optionbuttons, commandbuttons). What i m looking for is that on clicking a particular commandbutton, a prticular row (for eg : A100 - row) should become the top row on the screen.

Ajitpal S Padda

__________________
Ajitpal S Padda

Hello,
Can you be more specific when you mean "Top of the row"?
Do you mean "to move it physically to the top of the sheet" or "to scroll the screen so that it comes at top"?
Thanks for claryfying,
S.