Set combo to "" after user update in Excel form with VBA
Posted on 2011-03-16
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.