VBA example not working

[papa]

I have been reading about VBA so I can do some code stuff
in Excel. I have followed the following example out of a
book on 2 different computers - but it does not work.

What I have is:
Private Sub CmdClickMe_Click()
frmCH01.Caption = "I have a new caption!"
MsgBox "The caption has been changed."
End Sub


What I get is:
Run-time error 424
Object required.

I don't understand what the problem is.

TIA
papa

 

[Tom Ogilvy]

Private Sub CmdClickMe_Click()
frmCh10.Caption = "I have a new caption!"
MsgBox "The caption has been changed."
End Sub

worked for me on a form name frmCh10 with a commandbutton CmdClickMe and
the code in the userform module

try

me.Caption = "I have a new caption!"

if you continue to have trouble.

 

[Ken Macksey]

Hi

Did you first create a userform and then name it frmCH01 ?
Open the vbe and create a new userform and name it frmCH01 in the properties
dialog.
Change the code to this and re-run.

frmch01.Caption = "I have a new caption!"

MsgBox "The caption has been changed."

frmch01.Show

And you should see the form with your caption.


HTH

Ken

 

[Bob Phillips]

Have you put that code in the form module, not a standard code module?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

that helped thanks.
The book told me to name the command button something else
and then gave example code with the wrong name.