I have an Active X combo box in a spreadsheet. When you click the drop down arrow on the right, the whole combo box moves a few millimetres to the right and down. You then have to re-select the drop down arrow to select one of the data items.
Any idea why the Combo Box moves when selected...
Hi guys,
I'm at a loss as to why my Active X Combobox won't work even after unlocking all the cells the combobox is referencing and inserting unprotect and protect code in VBA editor. Here is the code:
Private Sub Worksheet_BeforeDoubleClick _ (ByVal Target As Range, _
Cancel As Boolean)...
I currently have 2 separate comboboxes pointing to separate named lists.
I added some vba to create an autocomplete dropdown.
The code points to the correct combobox and references the correct list for each combobox.
My problem is that when I type in the first one, select a value from the...
I know the easiest way to do a dependent drop down is with Data Validation. However, the options in my lists are too long to use this (unfortunately, I cannot make them shorter.) I need to be able to create a 2 dependent drop downs (total 3 that cascade depending on the selection.)
I was...
Hi All,
Although this is my first post on here.. Thank You to the Forum as I've been following and learning on here for over a year now.
As per my subject title, I have quite a few things I'm trying to work on and they are all linked to the Active X Combo Box.
I'm running Windows 7 and Excel...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.