Thanks for your help RobBroekhuis. That has solved my problem really. I dont think the button jump to feature was feasible.
one last query i have though is whether it is possible to select a row on another sheet without activating the sheet first. I want to traverse through records on sheet1...
I have two worksheets. On one I have a sheet which displays a form (consisting of VB controls). On the other sheet i have a list of records.
Sheet one displays each record on sheet 2 one at a time and has navigation buttons to move to next record etc...
I need to be able to click on a record...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.