command button on worksheet(not user form)

[jiemei1]

I am tryng to put a command button on my worksheet. once I click the button, I should be able to get:

Private Sub CommandButton1_Click()
End Sub


the problem is that I am not getting the result I want. Any one know why? I am using Excel 2003.


Thanks

 

[johnwm]

Forum707 is for VBA stuff. This forum is for writing ActiveX controls and DLLs using VB6. Read faq222-2244 to get some guidelines on forum usage.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller