View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default using textbox for cell values

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