using textbox for cell values

[Gus Chuch]

This is my first attempt at VB for excel. All I’m trying to do is write to a
cell using a form with a textbox and a command button.
I would think you would do it something like this but it’s not working.
Private Sub CommandButton1_Click()
Sheet1.Cells(A, 1) = TextBox1.Value
End Sub

Any help would be appreciated
Gus Chuchanis

 

[RB Smissaert]

What is A?

Try:
Sheet1.Cells(1, 1) = TextBox1.Value

RBS

 

[OssieMac]

Hi Gus,

When you use Cells the row/column reference is back to front to Range method
and if you use the alpha column reference then enclose it in double quotes:-

Sheet1.Cells(1, "A") = TextBox1.Value

Using numeric column reference:-
Sheet1.Cells(1, 1) = TextBox1.Value