Change the properties of a userforn textbox based on the backcolor of a label

[chipnputt]

The code below is for a userform that is created at runtime. The form lists all of the possible selections that a user may chosen in the Data Entry sheet and he can enter the order he would like to see the results in a report sheet. I would like to improve the design of the form by changing the backcolor of the label of the unused items, clear and disable the corresponding textbox. The following code changes the backcolor but I am stumped getting to the corresponding textbox. Can anyone help?

Please Login or Register  to view this content.

[AlphaFrog]

Try something like this (not tested)

Please Login or Register  to view this content.

[chipnputt]

AlphaFrog thank you for your assistance. Had to modify the code a little but you placed me on the right track.

[AlphaFrog]

You're welcome and thanks for the feedback.