Hello
I have a userform to fill a sheet with information about different students behaviour. I need to select the student number and fill a selection with information.
I need same help in two questions.
I use 10 commandbutton to select diferent cell on a sheet. (the student)
Question 1: Is possible to have a listbox to select diferent cell on a sheet?
I have 12 buttons. (Student behaviour)
The button 1 to 11 have this code:
Private Sub CommandButton1_Click()
ActiveCell.FormulaR1C1 = "AM"
ActiveCell.Offset(0, 1).Range("A1").Select
End Sub
The button 12 have this code:
Private Sub CommandButton12_Click()
ActiveCell.FormulaR1C1 = "AM"
ActiveCell.Offset(1, -11).Range("A1").Select
End Sub
Question 2: Is possible to have just one button to do all the actions?
Thank you for your help.
Best regards.
Luís Moreira
I have a userform to fill a sheet with information about different students behaviour. I need to select the student number and fill a selection with information.
I need same help in two questions.
I use 10 commandbutton to select diferent cell on a sheet. (the student)
Question 1: Is possible to have a listbox to select diferent cell on a sheet?
I have 12 buttons. (Student behaviour)
The button 1 to 11 have this code:
Private Sub CommandButton1_Click()
ActiveCell.FormulaR1C1 = "AM"
ActiveCell.Offset(0, 1).Range("A1").Select
End Sub
The button 12 have this code:
Private Sub CommandButton12_Click()
ActiveCell.FormulaR1C1 = "AM"
ActiveCell.Offset(1, -11).Range("A1").Select
End Sub
Question 2: Is possible to have just one button to do all the actions?
Thank you for your help.
Best regards.
Luís Moreira