VBA caption command
Hi.
I want to add 100 to the rectangle (named 'ascore') when clicking the up arrow that's right next to the rectangle (see screenshot). The macro is assigned to the up arrow shape. My VBA code is below. It does not work yet.
Error message when run the code in the debugger:
Run-time error '420'
Object required.
Sub ascoreplus()
ascore.Caption = ascore.Caption + 100
End Sub
Anyone sees where I made a mistake?
Thank you very much in advance!
Sophia
|