Forum Discussion
Solved
How write vba code for three textboxes on form
How write vba code for three textboxes on form. Textbox1 get data from worksheet for display on form. Textbox2 get data from worksheet for display on form Textbox3 put data on to workshee...
See the attached version.
Set the ControlSource property of the text boxes to the cell you want them to be linked to.
If you set the Enabled property of TextBox1 and TextBox2 to False, the text boxes will be for display only.
Leave Enabled set to True for TextBox3. The user will be able to change the value of the linked cell by editing this text box.
textbox1 how write vba code for form get data from worksheet show on textbox1. textbox2 how write vba code for form get data from worksheet show on textbox2. textbox3 how write vba code for form put data into worksheet.
How to write vba code to make form to work.
Thanks You
I showed you how to do that in my previous reply!
I try get these codes not working for me one my friend found them
'FORM WORKSHEET TO SHOW ON THE FORM TextBox1.Value = Worksheets("Sheet1").[A4].Value TextBox2.Value = Worksheets("Sheet1").[B4].Value PUT DATA INTO WORKSHEET Worksheets("Sheet1").[C4].Value=TextBox3.ValueThanks You
