Forum Discussion
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 worksheet.
I have a label on the form disregard. I can not delete label from my phone
Thanks You.
See the attached version.
5 Replies
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!
