| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scrolling too fast on one sheet | Excel Discussion (Misc queries) | |||
| One sheet is scrolling 3500 per inch moved | Excel Discussion (Misc queries) | |||
| have sheets 2 and 3 scroll the same when scrolling sheet 1? | Excel Discussion (Misc queries) | |||
| have sheets 2 and 3 scroll the same when scrolling sheet 1? | Excel Worksheet Functions | |||
| Stopping A Sheet From Scrolling | New Users to Excel | |||
![Pierre[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
