Removing Selection from Combo Box

**jamesryan** · 08-13-2008, 04:34 AM

Hi All,

I have a few combo boxes on a worksheet (from the Forms toolbar) which a user selects data from.

If the user makes a mistake then there is a Button which runs a macro which should clear the combo boxes out (i.e. leave them blank).

For some reason the macro to clear out the combo boxes does not appear to be working. It deletes the data in the cell that the combo box is linked to however the combo box entry stays the same.

Does anyone know how to remove this please?

Thanks

James

**Stuie** · 08-13-2008, 04:38 AM

Hi jamesryan,

You need the following peice of code to clear all items from box

ComboBox1.Clear

(change ComboBox1 to your combox name)

**royUK** · 08-13-2008, 04:54 AM

I generally use the controls from the Controls ToolBox. If you actually need to remove the contents of a Forms ComboBox then use

'change "Drop Down 1 to suit
   ActiveSheet.Shapes("Drop Down 1").Select
    With Selection
        .ListFillRange = ""
    End With

Thread: Removing Selection from Combo Box

Thread Tools

Display

Removing Selection from Combo Box

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions