View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Derek Derek is offline
external usenet poster
 
Posts: 51
Default Change text in a cell from a command button on a Userform

I am getting a runtime error 1004
I do realise that I am not addressing the cell correctly but cannot find out
how do do this.
I have 1 Sheet, 1 Userform and 1 module. My code (below) explains what I
want to do.
Any code to overcome this error would be greatly appreciated.

Private Sub CommandButton2_Click()

Sheets("sheet1").Range("K1").Text = "Off"

End Sub
--
Derek