ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Linking Cell Data to Text Boxes on a Form (https://www.excelbanter.com/excel-programming/417286-linking-cell-data-text-boxes-form.html)

JAD

Linking Cell Data to Text Boxes on a Form
 
I am creating a VB form that will contain (50) selections with each selection
containing a toggle button next to an associated text box containing a
selection name. The (50) selections for the forms (50) text boxes are located
on a protected worksheet as global inputs that are changed infrequently. My
goal is to show the global input data, located in cells on another worksheet,
in their associated text box located on the VB form. How do I link the text
box back to the Excel cell that contain, in essence, the master item. Any
help would be appreciated. Thank You, JAD

JP[_4_]

Linking Cell Data to Text Boxes on a Form
 
I am trying to visualize your form.

You have 50 text boxes paired with 50 command buttons. You want to
display each of 50 items inside each text box.

Is that correct?


--JP

On Sep 18, 12:32*pm, JAD wrote:
I am creating a VB form that will contain (50) selections with each selection
containing a toggle button next to an associated text box containing a
selection name. The (50) selections for the forms (50) text boxes are located
on a protected worksheet as global inputs that are changed infrequently. My
goal is to show the global input data, located in cells on another worksheet,
in their associated text box located on the VB form. How do I link the text
box back to the Excel cell that contain, in essence, the master item. Any
help would be appreciated. Thank You, JAD




All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com