Hi can anyone help please I have a sheet called recording and the data is written down the sheet very fast how can I make the the scroll bar scroll down automatically so I can what data is being written using vba
Hi can anyone help please I have a sheet called recording and the data is written down the sheet very fast how can I make the the scroll bar scroll down automatically so I can what data is being written using vba
can you post the code that writes the data?
If someone has helped you then please add to their Reputation
Hi I'm sorry I can't post the code as it is used for my work and I can't strip the code down as I don't know vba well. The code is written down the rows one row at a time I just need the scroll bar to follow this and move down with the data
Then Im guessing here but after the line that outputs the data (should be something like "Cells(1,2).value = xxxxxx" or Range("A1") = xxxxx) then add a line that basically takes the same Cells or Range value and append it with .Select
eg
orPlease Login or Register to view this content.
which I believe, should select the cell thats just been added to and therefore scroll the screen accordingly.Please Login or Register to view this content.
Of course you can always usePlease Login or Register to view this content.
.. and don't forget to have fun!
Bogdan.
mark SOLVED and Add Reputation if my answer pleases you
Hi thanks for your help but I'm a bit of a novice with VBA so I need to scroll from A1 to A120000, could anyone help with writing the sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks