Hi fellow VBA'ers
So...
I have a userform with 8 tabs.
To make life easier for my users I want hide hide three of them, unless the are required (reducing clutter).
But.
At the end I do error checking to ensure that some mandatory fields have been completed.
I used to be able to select the blank field by using
UserForm8.MP1.Value = 5
UserForm8.MP2.Value = 2
UserForm8.Frame14.SetFocus
Now I can't use that method as the value will change depending on how many tabs are displayed.
I've tried
UserForm8.MP1.pages ("page6)
UserForm8.MP2.Value = 2
UserForm8.Frame14.SetFocus
But it gives an error, I tried looping through to get an index number with no luck either.
Your help would be greatly appreciated thanks :-)
Regards
Kes