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.
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.
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
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.
Don’t have an account yet? Register yourself now and be a part of our community!