You don't need an if as the button has a click event which is effectively
telling your code that it has been clicked.

Private Sub CommandButton1_Click()
Msgbox "Button1 clicked"
End Sub

--

HTH

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

"Manisha" wrote in message
...
i hav a userfrom, on this 2 button.
to 1 of these i want to attach an IF statement sayin if
this button is pressed enter data onto 2nd line in the
spreadsheet. does ne1 kno the correct terminology??

thanks