<div>
You need to add &quot;&quot;&nbsp;as a possible value in the value list. Then you can set the box to an empty string.<br />
<br />
Kevin
</div>


You need to add "" as a possible value in the value list. Then you can set the box to an empty string.

Kevin

<div>
It is an item, but it simply won't reset.
</div>


It is an item, but it simply won't reset.

<div>
Then use the Clear method:<br />
<br />
ComboBox1.Clear<br />
<br />
Kevin
</div>


Then use the Clear method:

ComboBox1.Clear

Kevin

<div>
<div class="content wysiwyg-content">
I have a form whereby theuser updates underlying data. &nbsp;It can be an update to existing data or the user can close the account. &nbsp;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. &nbsp;However, the &quot;group&quot; combo box still reflect the group the user selected. &nbsp;How can I simply set this to an empty text string? &nbsp;I don't want the drop-down items to disappear, I just want a blank control. &nbsp;I tried setting it to &quot;&quot;, but that did not work.
</div>
</div>


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.

Set combo to &quot;&quot; after user update in Excel form with VBA

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Set combo to &quot;&quot; after user update in Excel form with VBA

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