G
Greg Maxey
Today I been working on some enhancements for using a UserForm listbox as a
work around for the 25 item limit in dropdown fields.
Perhaps the whole exercise is like trying to build a better mouse trap, but
I wanted to share it with this group for two reasons.
a) It might work for you.
b) I don't pretend to be anything more than a VBA novice and I always
welcome constructive comments and criticism
Basically the problem I had with the existing method
http://support.microsoft.com/kb/198561/en-us is that a dropdown field in a
protected form doesn't behave as a combobox. The user picks from the list
or doesn't pick at all.
The method I developed uses a ListBox and validates the textfield entry on
exit to sure the user didn't dismiss the Listbox and put in their own
invalid text.
You can view the method here. Thanks for any comments.
http://gregmaxey.mvps.org/FormField_UserForm_ListBox.htm
work around for the 25 item limit in dropdown fields.
Perhaps the whole exercise is like trying to build a better mouse trap, but
I wanted to share it with this group for two reasons.
a) It might work for you.
b) I don't pretend to be anything more than a VBA novice and I always
welcome constructive comments and criticism
Basically the problem I had with the existing method
http://support.microsoft.com/kb/198561/en-us is that a dropdown field in a
protected form doesn't behave as a combobox. The user picks from the list
or doesn't pick at all.
The method I developed uses a ListBox and validates the textfield entry on
exit to sure the user didn't dismiss the Listbox and put in their own
invalid text.
You can view the method here. Thanks for any comments.
http://gregmaxey.mvps.org/FormField_UserForm_ListBox.htm