combo

  1. D

    Excel 2016 VBA UserForm shows nothing - no data

    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...
  2. L

    VBA for If one value is selected in a combo box ensure another combo box is completed

    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...
  3. M

    Would like to "deactivate" combo box in user form when user form is first opened

    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?
  4. M

    Open on-screen keyboard when clicking on combo box in a user form using vba...

    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.
  5. K

    Userform Code

    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...
  6. H

    Lock combo from 5 tumblers with 10 letters each

    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...
  7. A

    Add Numerical Tab Names in Combo box

    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...
  8. C

    Changing Values of Text Box on Main Form from Sub Form

    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...
  9. E

    Chart with 3 different values

    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?
  10. gheyman

    Combo Box List Rows limit

    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]...
  11. gheyman

    Access: TExt Box = Combo Box

    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...
  12. A

    MIN/MAX Value of a Range upon Combo Box Input

    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...
  13. M

    ComboBox - Cannot select combo box options

    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...
  14. M

    ComboBox Help - Drop down options disappear/reset after clicking an option in my combobox

    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...
  15. gheyman

    Access; Error Message on form fro ComboBox

    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...
  16. M

    VBA Combo Box autocomplete issue

    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...
  17. M

    Running VBA script every time a linked cell is updated through a combo box selection.

    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...
  18. M

    Running VBA script every time a linked cell is updated through a combo box selection.

    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...
  19. Q

    Update Text Field Based on Combo Box Field

    On a Form, there is a Combo Box Field which lists different Statuses (e.g. Open, Pending, Closed). Is it possible for the following to happen? When 'Status' is changed from 'Open', add the sentence to the end of the text field 'Comments' to be something like this: "05/05/19 - Closed - J.Smith"...
  20. Q

    Combo Box on Msg Box VBA

    I have a button which shows a Pop-Up Box asking the user to enter a name of a staff member. Is it possible to edit the Pop-Up so that instead of showing a free text box (where the user can enter anything), it shows a combo box instead which lists the staff names? If it helps, I currently have a...

Some videos you may like

This Week's Hot Topics

Top