[Gus Chuch]

This is my first attempt at VB for excel. All Im 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 its 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

"Gus Chuch" wrote in message
...
This is my first attempt at VB for excel. All Im 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 its not working.
Private Sub CommandButton1_Click()
Sheet1.Cells(A, 1) = TextBox1.Value
End Sub

Any help would be appreciated
Gus Chuchanis

[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
--
Regards,

OssieMac


"Gus Chuch" wrote:

This is my first attempt at VB for excel. All Im 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 its not working.
Private Sub CommandButton1_Click()
Sheet1.Cells(A, 1) = TextBox1.Value
End Sub

Any help would be appreciated
Gus Chuchanis