vb and excel

[vbguy03]

Hey.

I have text boxes in an excel worksheet, and I want to input data into these text boxes and then click a command button which puts these text values into a new row in another worksheet. Just wondering if there are any basic ideas how I can go about doing this.

Thanks

[RobDog888]

Welcome to the Forums.

Moved

What type of textboxes are they? ActiveX or Forms textboxes?

[vbguy03]

forms

[New2vba]

Try this, but with specifics changed to suit your spreadsheet/requirements. The textbox and command button can be on any sheet within the workbook.

Private Sub CommandButton1_Click()
 
'Declare your data type - note that if you set a specific data 
'type such as numeric, you must trap for non-numeric entries
Dim X As String
 
'Set variable equal to textbox value
X = TextBox1.Value
 
'Add data to cell A1 of Sheet2 - you can change this to any cell
'on any sheet witin the workbook
With ActiveWorkbook
    Worksheets("Sheet2").Range("A1").FormulaR1C1 = X
End With
 
'Note that each time you click the command button, the data in cell
'A1 will be overwritten with the data in your text box
 
End Sub

Hope this helps.

EDIT:

Just realised that you said your textboxes were forms type. This code relates to control toolbox textboxes. Are you sure you have form type textboxes in Excel? When I use forms in Excel (2003), the textbox FormField is not available.