scrolling a sheet with vb

[Pierre]

Hi all,

I use a form to fill an excel sheet.

The form appear over the excel sheet.

When someone start with an empty sheet,
he can see the lines that are created.

Bur after 30 lines the data is add but the user cant see it being add.

Is there a way to make the excel sheet scroll.

There is a scroll function but it is not working with sheet.

Any suggestion

regards,
pierre

 

[Ron de Bruin]

Hi Pierre

Look in the VBA help for

Application.Goto Range("A1000"), scroll:=True

Look also for

ActiveWindow.ScrollRow = 10

 

[Pierre]

thanks, it work fine



Ron de Bruin a écrit dans le message ...