Change text in a cell from a command button on a Userform

[Derek]

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

 

[TomPl]

Try:

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

 

[JLGWhiz]

The Text property is Read Only for the Range Object but is Read/Write for
everything else.