Hello,
I am currently working on a personal project involving a userform and a couple of worksheets.
The form contains buttons (next/previous for a range "A7 - H7") and the user is to navigate the worksheet with the buttons, with cell data displayed in the textboxes on the form.
Could someone suggest how I could have this running? I tried:
For next button (-1 in the previous button):
Range("a7:h7").Select
txtGSPno.Text = ActiveCell.Offset(1, 0).Value
At Form initialize:
Range("a7:h7").Select
txtGSPno.Text = Range("a7").Value
txtGSOST.Text = Range("b7").Value
txtGSOO.Text = Range("c7").Value
txtGSPV.Text = Range("d7").Value
txtGSPPQ.Text = Range("e7").Value
txtGSPTI.Text = Range("f7").Value
txtGSPL.Text = Range("g7").Value
txtGSPR.Text = Range("h7").Value
However, since editing data is also one of the features, I wanted to first be able to navigate freely in the worksheet and have any data in the cell displayed in my elected textbox without a problem. Currently, on navigation, my buttons stop working after one click and plus there are a number of textboxes for a number of columns/rows.
To summarize:
I have to be able to navigate the worksheet with my buttons, and select a range of cells (in this case a7 - h7) and have my textboxes display the information. How do I navigate and display without limitations in VBA.
I am comfortable with VB, but VBA is a different thing and it's my first project... thanks for all the help, appreciated.
Bookmarks