VB in EXCEL button problem 3

[realbeginner]

Hi. I want to use VB to create a button in EXCEL which puts a 1 in a cell then moves to the row underneath. If I click the same button I want it to put a 1 in this new cell and move downwards as before. I know this is simple stuff but I'm really stuck! (I can put a button in and record a macro) [This is so I can use EXCEL on an interactive whiteboard in the classroom to do the register]

Many thanks.

 

[Asspin]

Give this a try.

With ActiveCell
    .Formula = "1"
    .Offset(1, 0).Select
End With

 

[sawebs2]

You want to use VB to create a button?

 

[realbeginner]

Many thanks! That was really helpful.

 

[realbeginner]

Hello again. I wanted to change the colour of my buttons and I'm having problems. Can you see what I'm doing wrong here?

CODE
Sub Button1_Click()
'
' Button1_Click Macro Present

With ActiveCell
.Formula = "1"
.Offset(1, 0).Select
End With
Button1.ForeColor = RGB(0, 255, 0)
' Colour - Green
End Sub

 

[PHV]

You wanted perhaps this ?
Button1.BackColor = RGB(0, 255, 0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[realbeginner]

Thanks! There is still a problem. Everytime I try to run it says:

Runtime error 424 Object required

Any suggestions? Have I got the code in the wrong place?