Set combo to "" after user update in Excel form with VBA

I have a form whereby theuser updates underlying data.  It can be an update to existing data or the user can close the account.  What I would like (and can't seem to get done), is when the user closeds an account, the data is removed from the underlyiing worksheet and the form empties.  However, the "group" combo box still reflect the group the user selected.  How can I simply set this to an empty text string?  I don't want the drop-down items to disappear, I just want a blank control.  I tried setting it to "", but that did not work.
Sandra SmithRetiredAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
Another technique:

ComboBox1.ListIndex = -1

This maintains the list while clearing the entry field.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
You need to add "" as a possible value in the value list. Then you can set the box to an empty string.

Kevin
0
 
jppintoCommented:
cboName.Text=""
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Sandra SmithRetiredAuthor Commented:
It is an item, but it simply won't reset.
0
 
zorvek (Kevin Jones)ConsultantCommented:
Then use the Clear method:

ComboBox1.Clear

Kevin
0
 
Sandra SmithRetiredAuthor Commented:
That did it, thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.