Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Jan 19, 2024
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 worksheet.

 

 

I have a label on the form disregard. I can not delete label from my phone

 

Thanks You.

  • sf49ers19238597 

    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.

Resources