activex controls

I have add Combobox to page. Dim Combo As ComboBox Set Combo = ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, DisplayAsIcon:=False, Left:=50, Top:=80, Width:=100, Height:=15).Object And I need to add TextChanging events to this Combobox, but how to do this?

Hi all, I have a single worksheet with 20+ data validation dropdowns. I want to insert a Command Button that will reset all the dropdown cells to the first option on the dropdown list when I click it. Having never used Macro/VBA before, I’ve tried researching the appropriate code to make this...

Hello everyone! I am dynamically creating a bunch of ActiveX/OLEObject comboboxes. Each combobox needs to have a dynamically created Click event handler. I am able to do this, no prob. The problem is that, occasionally during a session I want to delete all of the comboboxes and their...

Hello, I am creating a UserForm for the first time and am having a bit of trouble getting a macro to run when an option button is clicked. To avoid writing multiple lines of code to hide various ActiveX controls depending on which option button is clicked, I've written macros to hide various...

As the title states, I have some VBA code setup to export sheets to a PDF report. There are check boxes on the worksheet to show and hide certain columns. After I run the code and successfully export to PDF, the form controls no longer work - I clicked them an nothing happens. Even if I save and...

Hey folks, Working on a project where I have multiple ActiveX combo boxes throughout a sheet, and through other actions, they are moved & sized with cells, therefore sometimes hidden. They cannot remain static, and I've noticed that when they are hidden & the workbook is saved & closed, the...

Hi all I have been using activex catalog buttons in one of my excel tools, but suddenly it stop working for several users (including me) - weird is that it is still working for others. I have compared versions of Activex, Excel etc... but everything seems to be ok. Because of that we decided...

I developed a macro with Excel 2013 which includes ActiveX comboboxes that execute some code. When I open that file with Excel 2007 and click on the ActiveX controls the code is not executed, nothing happens. This has nothing to do with the December 2014 upgrade which I have not installed. I...

Hello All, I have a form that contains a list box populated with all of the worksheets in the current workbook. I need to be able to move the selected worksheets form the current workbook to another while keeping in mind the following: The list box may have one or multiple sheets selected...

Hi There, I am not new to Excel programming, but very new to using ActiveX Listboxes. My big question is, can those hold the data at all? When I close the program and open it again, all the data in the listbox control us gone.:confused: Thank you very much for your support. Ralf

So I'm dynamically adding a series of ActiveX checkboxes to a worksheet. Each checkbox represents a given product and the set of products varies based on the market I select in a combo box drop down. I have a class module that should control what happens on the click event for each newly added...