VBA : forms...

mjschukas · Jan 27th 2004

i now know how to create and call forms from a spreadsheet...

but now, how do i enter data in a texbox on the form and pass to a cell in the spreadsheet...?

thanks.

Colo · Jan 27th 2004

Hi mjschukas

You can pass value like this.

'a Cell to a Textbox on the Form
TextBox1.Text = Range("A1").Value

'a Textbox on the form to a Cell.
Range("A1").Value = TextBox1.Text

Dave Hawley · Jan 27th 2004

Hi mjschukas

You could also set the ControlSource Property to the needed cell, eg

'Sheet1'!A1

This will then feed to cell A1 on Sheet1 and cell A1 will also feed the TextBox.

Participate now!