combobox activex

Trying to get VBA to select first item in a combobox. What do I need to add? Getting below error on this part at the end of code below: : Worksheet.ComboBox1.ListIndex = 0 If fixed_range.Row = n Or Not Intersect(ActiveCell, Range("B7")) Is Nothing Then MsgBox "That was a last step." &...

Hello, Pros, I need some help regarding the Dependenct Combobox on another Combobox. I've attached the Link of file below which explains everything. please help !!! Link : Book1.xlsm

Hi every one, sorry for my bad english i found this thread on my searches and i loved the answer of the post#2 https://www.mrexcel.com/board/threads/how-to-use-a-combobox-with-autocomplete-and-search-as-you-type.1098277/ Option Explicit Dim IsArrow As Boolean Dim ListRowsMaximum As Long Dim...

Hi, So after working for couple of weeks my macro suddenly stopped working and keeps giving me a compile error. I also cannot create any new activex items anymore in my excel files. I heard there were an update on VBA? But I dont believe that would cause an issue like this? Is there also...

I have a need: create a combo box (or maybe something else) to filter my file by COLOR and INCLUDING ALL OPTION. sample data listed below. Goal is when color red, orange, or yellow selected at B7 Combo Box, rows under column c will be filtered accordingly with understanding that any uncolored...

Dear All Experts , I have created a drop down list with ActiveX comboBox to make it Autocomplete when users type data. I got the Help to create this combo box by searching for that topic. Right now i have Orders sheet and Cell B2 which is working fine. But i want this feature in my whole B2...

Hello All, Need help with my work. I have a userform that has multiple checkboxes and a label. What I am looking forward is: 1. I want to copy the label into the textbox when one of the checkbox is selected. If multiple selections, one label only for the entire selection. 2. I want to copy the...

Hi, I used a combox that fills as you type in a project with a long list. I used this option instead of the regular dropbox, because at time we have more than 1000 options to choose from, and it easier for the user to start typing and selecting. The only issue I am having with the combox, is...

Hello Gurus, I am currently having trouble making my ComboBox ActiveX hide and unhide columns based on range of text in a row. I did not have an issue with the formula when it used to be a dropdown, but when I tried to convert using the ComboBox, I am having issues. What I would like this...