Create VBA Active-x ComboBox And then delete it when finished

**Pegaasus** · 02-21-2013, 10:46 PM

I'm almost an newbie. I can't get it to work..

This is my Objective:
Create VBA Active-x ComboBox with attributes and named ListFillRange
are selected within an defined cell range. Then delete the
Active-x ComboBox when another cell are selected.

Info:
The lists are from different worksheets in the workbook.

This code is my project:

Please Login or Register  to view this content.

**AlphaFrog** · 02-22-2013, 06:30 AM

This may be a little easier.

Manually create an ActiveX combobox anywhere on your sheet. Set its font and visual appearance the way you want it. Name it MyCBO.

The code below will position, size, and populate MyCBO based on where the user clicks or just hide it when not needed.

Please Login or Register  to view this content.

**Pegaasus** · 02-23-2013, 02:55 AM

Thanks AlphaFrog, that did the task.

I've a range with 14 separate merged cells from HJ4 to IK4, no error and still not working.

With this code i tried:

Please Login or Register  to view this content.

**Pegaasus** · 02-23-2013, 05:57 AM

Have another code that I've made before and that don't work together with your "AlphaFrog" code..

http://www.excelforum.com/excel-prog...77#post3133877

By it self "AlphaFrog" code.. works perfect..