Excel VBA Form Problem - ggrrrrrrrr!!?

[GreenthumbUK]

Hello,

Perhaps you can help me
1.I want a form to appear when the spreadsheet is opened.

on this form is a box to enter data and a button.
2.Whats the coded needed to copy the text entered in to cell a1 of sheet1 when the button is hit, i know it goes under the click event on the button but i cant figure it out, I think I may need to dim as integer to do so.

thanks.

 

[mndrlion]

Private Sub CommandButton1_Click()
    ActiveSheet.Cells(1, 1) = TextBox1
End Sub

 

[PHV]

1) Load and Show the UserForm in the Workbook_Open event procedure
2) See the mndrlion's post

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[GreenthumbUK]

as east as that, thanks peep's - was just about to go for a fag in frustration!