scrolling a sheet with vb
 

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

scrolling a sheet with vb
 

Hi Pierre

Look in the VBA help for

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

Look also for

ActiveWindow.ScrollRow = 10


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pierre" wrote in message ...
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

scrolling a sheet with vb
 

thanks, it work fine



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

Look in the VBA help for

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

Look also for

ActiveWindow.ScrollRow = 10


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pierre" wrote in message
...
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