combo

Dear Excel Experts I need urgent advise on how to do a custom search input text in combo box under protected sheet. The property of combobox is unlock as well as all the cells link to that box are unlock. Below are vb code for this combo box. Private Sub ComboBox1_GotFocus()...

Small spreadsheet with 3 columns - first name, surname and status. Status can be any of several options including “withdrawn”. Filter to hide rows with “withdrawn” status works fine. Rows disappear as intended and filter is still in place if workbook is closed and re-opened. Problem - i am...

I would be grateful if there are any suggestions - I have been wrestling with this for several days. I am try to use a UserForm called from VBA to offer a drop down list for user selection. When I create this Userform with a Combobox the box appears but there is nothing in it? So I went for...

Hi, I'm very new to VBA and was wondering if somebody could help me with the following I have a user form with multiple combo boxes and text boxes. One of these combo boxes has three options, all entered via VBA If the option of Hotel Supplies is selected (and only this option), I want to...

When a command button opens a user form, the combo box in the user form has a blinking cursor right away. I would like the combo box to not be selected when it is first opened. Any ideas for lines of code?

I'm using a microsoft surface pro 2 with windows 10 and would like to have the onscreen keyboard show when I tap my combo box in my program's user form. Any ideas? I have found a few forums with similar questions but I still get errors.

I am very new to Userforms and have learned all I know by researching examples. I'm thrilled with a userform I set up, but can't figure out one final detail. I have loaded a combo box with student names pre-loaded a worksheet using the following: Private Sub UserForm_Initialize() 'Empty...

I have padlock for my pool that has 5 rings with 10 letters each. I had to change the combo a few days ago and for the life of me i cant remember what i changed it to. i have a list of the letters on each dial and wonder if i can use excel to come up with all possible combo of words using only...

I have sheet tabs name by the year. Only 1 sheet tab will be visible. All other tabs will be hidden. The code below will populate the userform with years (i.e. 2019, 2018, 2017, etc). My current sheet tab (2018) is visible. I would like the combo box to not display the year in the combo box...

I want to change the value of a combo box on a main form based on the update of a combo box on a subform. I have the following: Private Sub cmbSubCombo_AfterUpdate() If Me.SubCombo.Value = 1 Then Me.Parent!cmbMainCombo.Value = 1 Me.Parent!cmbMainCombo.Locked = True If...

Hi does anyone know a way of charting 3 different data formats I have Number, %, and time that I want on one chart, I can only use the combo chart to do 2 not the 3 Can anyone help?

I have a Combo Box that has 6 columns The source of the data for the list is huge. There is over 30k rows SELECT [ModelGeneral_vluItem].[TotalLeadtimeDays], [ModelGeneral_vluItem].[ItemID], [ModelGeneral_vluItem].[ItemDescription], [ModelGeneral_vluItem].[LastRevisionID]...

I have a Combo Box (unbound) that when its changed, I want another field (a bound text box) to equal what was selected in the Combo box. I tried versions of these, but its not working (two examples) Private Sub ComboItemID_Change() Me.ITEMID = [ComboItemID] End Sub Private Sub...

Ciao All ~ Attempting to return the minimum value of a Range based on input from a Combo Box. Combo Box returns value in cell BM6 : 1,2,3,4 Set this table up to use Index/Match formula on : BR BS BT BU 1 S13:S49 W13:W49 AA13:AA49 2 T13:T49 X13:X49...

I have a combo box that has a ListFilledRange property value of a particular column in my spread sheet. My code is fairly simple after this... Private Sub ComboBox1_Change() Me.ComboBox1.DropDown End Sub Can anyone tell me why when I click on a combo box selection from the scroll down...

I have a combo box on a userform that is connected with a formula. It's similar to an autocomplete combo box. Anyways, I have my program working fairly smoothly except for the fact that after it narrowing down my search, I will click on SOME options and it clears itself and it wants me to type...

Error: "The value you entered isn't valid for this field" The combo box, where I get this message, is a bound field to a table. The Field on the table is tied to an ODBC table. In the Data Type, for this field, I used the Lookup Wizard to create the list. But what is happening is that the...

I have a script for my a combobox that is in a userform (GUI). The combo box uses a formula called "DropDownList" that I made to enable a particular type of autocomplete feature to my combo box. My program works as follows: After I start typing in the combo box and it narrows down my search, I...

So I have an issue in my excel file where I have a cell that is bound with a combo box. Every time the combo box selection is chosen, the linked cell will, of course, automatically contain the contents of the combo box. I then want my VBA script to automatically open an excel file on my desktop...

So I have an issue in my excel file where I have a cell that is bound with a combo box. Every time the combo box selection is chosen, the linked cell will, of course, automatically contain the contents of the combo box. I then want my VBA script to automatically open an excel file on my desktop...