Hi All,
would someone help me or point me in the right direction?
i have a active x combobox which is linked to a cell O1 and it returns a listfill range. i use it to search from a long list of suppliers, which is setup a table and it returns what im looking and it works great.
What i would like todo is to be able to clear the search in the active x combobox after i have finished searching, which would be assigned to a button to clear. i can clear the box using a macro, but the dropdown box appears and i have to click inside the combobox to remove it from view. is there a VBA code to clear the box for future searches?
many thanks inadvanced.
Mattless1
would someone help me or point me in the right direction?
i have a active x combobox which is linked to a cell O1 and it returns a listfill range. i use it to search from a long list of suppliers, which is setup a table and it returns what im looking and it works great.
What i would like todo is to be able to clear the search in the active x combobox after i have finished searching, which would be assigned to a button to clear. i can clear the box using a macro, but the dropdown box appears and i have to click inside the combobox to remove it from view. is there a VBA code to clear the box for future searches?
many thanks inadvanced.
Mattless1