Title:
Excel UserForm Combo Box Match
Video:
Description:www.contextures.com In an Excel UserForm with combo boxes, change a setting, so users can only select valid items from the drop down list. With the Match Required setting on True, you can't type invalid entries in the combo box. If the Excel VBA code also resets the combo box to blank, you can change the item list, by adding Select at the top. This will prevent an Invalid Property Value error message, if the combo box is reset to blank.
Published:
12/Jun/2011
Excel UserForm Combo Box Match
Video:
Description:www.contextures.com In an Excel UserForm with combo boxes, change a setting, so users can only select valid items from the drop down list. With the Match Required setting on True, you can't type invalid entries in the combo box. If the Excel VBA code also resets the combo box to blank, you can change the item list, by adding Select at the top. This will prevent an Invalid Property Value error message, if the combo box is reset to blank.
Published:
12/Jun/2011
No comments:
Post a Comment