activex combobox

Hi all, Created an ActiveX ComboBox with search suggestions that automatically refilters ("shrinks") as the user types (KeyUp event). The ComboBox is "floating" and sizes/positions itself depending on whether or not the ActiveCell intersects certain rows/columns. I've noticed that whenever the...

Hey I made a test combo box for another project. Long story short, the combo box suddenly won't let me type. I checked the preferences so that its using the correct listrange and the style is set to "Combo". It was working perfectly fine then suddenly stopped. No VBA has been used. Trust...

Hello everyone, I have this issue that I've been struguling with for 2 days. I have an activex combo box called EmpresaCB which is located in a sheet called "Registro", the thing is that this combo box has to be populated with information that is located in a different sheet called "DB" This...

Hi everyone, I defined a ActiveX ComboBox named "cmbPeymankar", a Text Box (ActiveX control) called "txtNewPeymankar". a Command Button (ActiveX control) called "Add". I have a table named "Table1" in sheet "DATA" so that the first column of Table1 contains the names that should be displayed...

So i have multiple comboboxes in a worksheet. Is there a way i can fill all of them with the same listfillrange? The code for that for one combobox would be: Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Set col =...

The image shows an ActiveX Combo Box On clickin the drop down the button does not present the linked list, instead it presents another drop down button inside the list area which when clicked presents the list required. Not all persons in my team have the issue. Changeing the combo box...

Hi there, I have an activex combobox called ComboxC1. This is populated with a range of colours. When a colour is chosen i want a textbox "TB1" to be populated with the result. In sheet2 I have a series of different named ranges. For TB1 the answer is contained in range "ColourFoundation"...

Hello everyone, I am having a lot of problems in finding some material which could help me learn how to filter a pivot table with an ActiveX combo box set in another Sheet and I was hoping in some help of yours. ;) I would like to make a dynamic combo box, which updates automatically whenever...

Hi all, I've recently encountered some strange behaviour while using an embedded active-x combo box on a worksheet, i hope someone can shed some light on. I've basically got a worksheet with 3 embedded activex combo boxes which are used as quick filters for a table. The filters are controlled...

Hello, Long time answer searcher, first time poster. Still limited macro knowledge but I have usually been able to solve my macro-writing problems with a few searches and sometimes cobbling together different answers that I find online. No such luck this time. I have the macro below (found...

I am trying to create a form in excel. With certain questions the user can select multiple options. For instance: What type of fruit would you like? (I used an active x combo box for this) No Fruit Apples Oranges Pears Grapes I want the user to be able to pick multiple options at once...

HI I have added 2 combo boxes to a spreadsheet. The 1st is used to select a BU and the second is a dependant drop down for selecting a sub BU based on the BU chosen in combo box 1. I have used this sort of set up before and it has worked fine. However, ComboBox2 doesn't seem to display the...

Is it possible to "conditionally format" an ActiveX combo box like you can a cell? What I am wanting to do is require a selection to be made from the combo box. I would like for the box to be red until a selection is made. Also, which is better to use? ActiveX or Form controls? I am very green...

Hi, I have userform4 and combobox1 that is filled from range that is in Table28. What i would like to do is possibility to change values inside that Table28. For example: Table28 values are: XXX ZZZ YYY WWW So, when i select XXX value in combobox, i get inputbox with question "Enter text to...

Hi Guys, I am creating a dashboard where I have 2 ComboBoxes (ActiveX - chose this because of the ability to do events such as '_change'). Background My first department lists a product category (i.e. Sport, Games, Clothes, Food etc) and the second ComboBox is dependent upon the selection of...

Hi Everyone, I want to create an XL table where every record utilizes the functionality of an ActiiveX combobox. So, anytime a new row is added to the table, an ActiveX combobox must also be added on that row, and its LinkedCell property set to a cell on the corresponding row. The end users may...

Hi there, Just wondering if anyone can help me. I have an excel report that uses activex comboboxes and triggers VBA when they are changed. The issue I have is that since MS rolled out an update earlier in the year, the report runs fine on some of the machines in my organisation, but doesn't...

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 guys, Wondering if you can help me. A certain spreadsheet works on my machine, but won't work on my colleagues machine. When I choose something from the activex combobox, it triggers code and does certain things. However, when I choose it from his machine, nothing happens...i.e. it...

Hi! I haven't been able to find an answer on this and my issue could be piecing together code I found on multiple forums. This worked fine with the first combo box I tried but I am unable to get this to work on subsequent worksheets. My goal is to have an ActiveX ComboBox drop down...