TryingToLearn
Well-known Member
- Joined
- Sep 10, 2003
- Messages
- 730
One userform is designed to "deactivate" members but retain their associated data. This is handled by renaming them to zzFirst Lastname and resorting the list.
To re-activate them on another userform, the zz is taken off their name.
This form's combobox has a default value of "Name". A dynamic range finds names after a "tag" name of Z Other in the list. If the default Name is cleared by the user and there are no other names in the list, hitting any other control on the form returns: invalid property value
and I can't seem to get out of it other than resetting the code.
I've tried various error traps but it doesn't seem to get as far as the traps. I tried an error trap in the Private Sub ComboBox1_Change() to no avail either.
Properties include:
fmMatchEntryFirstLetter
matchrequired true
Stepping through it I can see it get to ComboBox1_Change() but it stops there and returns the invalid....
I'm assuming the code of the ok & cancel controls don't matter here.
Any suggestions?
TIA
To re-activate them on another userform, the zz is taken off their name.
This form's combobox has a default value of "Name". A dynamic range finds names after a "tag" name of Z Other in the list. If the default Name is cleared by the user and there are no other names in the list, hitting any other control on the form returns: invalid property value
and I can't seem to get out of it other than resetting the code.
I've tried various error traps but it doesn't seem to get as far as the traps. I tried an error trap in the Private Sub ComboBox1_Change() to no avail either.
Properties include:
fmMatchEntryFirstLetter
matchrequired true
Stepping through it I can see it get to ComboBox1_Change() but it stops there and returns the invalid....
I'm assuming the code of the ok & cancel controls don't matter here.
Any suggestions?
TIA