Bob

You are still in "Design Mode"

Bring down the Control Toolbox bar and de-select design mode(top left icon)


Gord Dibben MS Excel MVP

On Mon, 29 Jan 2007 13:06:00 -0800, bob wrote:

Sorry, but I am still having trouble. From the Control Toolbox toolbar, I
selected Button and created a button called "CommandButton1". I right-clicked
and selected View Code. I pasted the code you provided, saved and returned to
Excel. But when I go to click the button, the button becomes selected,
resizing handles appear and the value in the C2 does not change. It appears
as if the button is not associated with the code.

What am I doing wrong?

Thanks,
Bob

"merjet" wrote:

From Control Toobox toolbar? If yes, right-click, view code, then:
Private Sub CommandButton1_Click()
Range("C2") = Range("C2") + 1
End Sub

Hth,
Merjet