Desperatly need help - customised forms

  • Thread starter Thread starter Rakujan
  • Start date Start date
R

Rakujan

Hi

I have been working on a customised form to enter data into a mar
sheet for a class of students, there are 21 pupils in my class howeve
I enter data via text boxes on a customised form I have created vi
visual basics.

I need to know if its possible to move down a column and have th
control source to be updated as i move down....please help as this i
very important..
Thanks:
 
Assume the textbox is on a userform

Private Sub Userform_Initialize()
Textbox1.controlSource = activeCell.Address(external:=True)
End Sub

Assumes you load the userform and show it for each row, then unload it
before you move on to the next row.
 
Back
Top