| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change text in a cell from a command button on a Userform
Try:
Sheets("sheet1").Range("K1").Value = "Off" "Derek" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change text in a cell from a command button on a Userform
The Text property is Read Only for the Range Object but is Read/Write for
everything else. "Derek" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Command Button from each Row to fill UserForm | Excel Programming | |||
| Command button calculation from Userform and Cell reference | Excel Programming | |||
| need to minimize userform via command button on itself | Excel Programming | |||
| Change active cell properties with command button | Excel Programming | |||
| Change active cell properties with command button | Excel Programming | |||
Linear Mode
