vba - Adding text to a combobox -
currently have simple combobox populates 3 items when clicked:
functionbox .additem "add blank issue" .additem "move existing issue" .additem "reorder issues" end
however, combobox empty before dropdown arrow selected.
when combobox appears want show like, "please select 1 of options below".
i tried setting 'value' of combobox 'test'. test shows in editor, not when run application.
i want make sure string goes away when down arrow selected , user cannot interact it.
any advice?
i can provide screenshots if unclear.
thanks!
goto design view of form, click on combo box in question , change text value want say.
edit - didnt see 2nd part of question
put in dropbuttonclick event. changing combobox1 needed
private sub combobox1_dropbuttonclick() combobox1.value = "" end sub
Comments
Post a Comment