Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
User Editing of Drop Down Box Data
3 views
Skip to first unread message
Jody Dobis
Jan 14, 2000, 3:00:00 AM1/14/00
to
Is there a property for the standard drop down box in vba that will
allow the user of a form to add (edit) his or her data if it doesn't
appear in the list. If not, is there a enhanced tool that I can add to
the vba toolbox that allows me this function. Thank you for your
response.
allow the user of a form to add (edit) his or her data if it doesn't
appear in the list. If not, is there a enhanced tool that I can add to
the vba toolbox that allows me this function. Thank you for your
response.
JAD
Tom Ogilvy
Jan 14, 2000, 3:00:00 AM1/14/00
to
Assuming combobox from the Controls ToolBox Toolbar:
For the combobox, the type can be DropDown or Combobox. If Combobox, the
user can enter a value in the "Edit box" portion. If dropdown, the user can
only select from the list.
For the combobox, the type can be DropDown or Combobox. If Combobox, the
user can enter a value in the "Edit box" portion. If dropdown, the user can
only select from the list.
You would have to write code in one of the events to add the hand entered
entry to the list.
Regards,
Tom Ogilvy
MVP Excel
Jody Dobis wrote in message <387F2A91...@ameritech.net>...
0 new messages