Macro for command buttons and results?

[Ashe77]

Hi, I need a macro genius's help please!

I am trying to put together an attendance register for a club I run and we use 5 different types of payment method (just to be difficult). I want to have 5 command buttons that relate to the 5 methods that when pressed for each student one by one will automatically fill in next to each student's name with the relevant method. I did a macro that placed the result in a designated cell reference but that ref stayed the same so each new student would just keep overriding the same cell results.


Does anyone have any ideas?

Many hopeful thanks in advance

Paul

 

[Roderick_E]

Posting the routine you did so far might help us help you. We might be able to help modify your current code to simply go to next student. Thanks

 

[Ashe77]

Posting the routine you did so far might help us help you. We might be able to help modify your current code to simply go to next student. Thanks

Hi

So, I've been using the below. Connected to a command box labelled "Card £15"

Sub Button1_Click()

Range("F1").Value = ("Card £15")

End Sub

Paul

 

[Roderick_E]

Hi

So, I've been using the below. Connected to a command box labelled "Card £15"

Sub Button1_Click()

Range("F1").Value = ("Card £15")

End Sub

Paul

How about it input into the active row -- this means the user clicks into the cell of the student they want to affect and then presses the button.

Sub Button1_Click()
cells(activecell.row,"F").Value = ("Card £15")
End Sub