The fields get changed, but when I UserForm1.Show, the form comes up blank. I want to be able to show or hide items in the form as needed.
I can get it to work if i explicitly type in the code. ie Userform1.Listbox1.Visible = False
For Multipage ... it will select the proper page and display or not as the program chooses, but that is as far as it goes.
What am I doing wrong?
For Each objControl In UserForm1.Controls
'Sheets("Controls").Columns(1) is a list of items i want to be visible, the rest should be hidden
iVisibleFieldsColumn = 0
iVisibleFieldsColumn = Application.Match(objControl.Name, Sheets("Controls").Columns(1), 0)
If iVisibleFieldsColumn > 0 Then
objControl.Visible = True
Else
objControl.Visible = False
End If
End If
Next objControl