I am creating a Drop Down box using excel macro and adding some items into it. Like below
With Worksheets(1)
Set lb = .Shapes.AddFormControl(xlDropDown, 10, 10, 100, 16)
lb.ControlFormat.AddItem "one",1
lb.ControlFormat.AddItem "two",2
End With
But, can anyone tell me how to clear the Drop Down box?
With Worksheets(1)
Set lb = .Shapes.AddFormControl(xlDropDown, 10, 10, 100, 16)
lb.ControlFormat.AddItem "one",1
lb.ControlFormat.AddItem "two",2
End With
But, can anyone tell me how to clear the Drop Down box?