Hello,
I am trying to format several text boxes in an userform by changing the value in a combination box. Essentially, I have a chart whose number of inputs corresponds to the number in the combo box. Therefore, I would like the text boxes that are not needed to disappear. I could obviously change each one individually, but this would make the code too bulky and unreadable. Below you can kinda see what I am trying to accomplish. Any suggestions would be great! Thanks!
Private Sub cbNumberOfPipe_Change()
If Me.cbNumberOfPipe = 1 Then
With tbA2
.BackColor = &HE0E0E0
.SpecialEffect = fmSpecialEffectFlat
End With
End If
End Sub
Bookmarks