However, being fairly new to Excel I do not know what the codes would be to allow the comboboxes to change options based on previous selections. This will help other members to find the solution easily. I am strongly considering using a Combobox Form Control or Combobox ActiveX control because, from what I have learned, they wouldn't be restricted by formula space. Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question.

Also I prefer to register the Activex through command prompt.

In 64 bit office, I am able to register the 64 bit ActiveX control by executing the below command in CMD and without any self-registering function in the ActiveX control.īut samething didn’t work in 32 bit office.Ĭan you please check my code and give feedback? Please how to make the same ActiveX control work in both 32 bit and 64 bit office. What is difference between Form Controls Vs Active X control in Excel - Quora. Differences between Excels Form Controls u0026 ActiveX Controls - Stack Overflow. I would like to have only one ActiveX control (i.e only one dll file) which should be registered in both 32 bit and 64 bit office. Forms Controls and ActiveX Controls in Excel - Peltier Tech. I have uploaded the modified code for your reference. Now, I am able to register in 32bit MS Excel (i.e MS Office 2010 32 bit) but still I am getting the same error in 64bit MS Excel (i.e MS Office 2010 64 bit). I have modified the sample and added COM attributes and self-registering methods.

I have downloaded the sample and tried to register as per your instruction.īut while registering, I got the error “The selected file does not contain any self-registering ActiveX controls.”

Form vs activex controls in excel