combobox value

  1. P

    Need help with macro for filtering worksheet data based on combobox control

    Hi folks, I am new to vba coding and struggling with a simple task. The requirement is that I have an excel document with two worksheets. One of the worksheet has just got a combo box and the other worksheet has data. The data in worksheet contains columns out of which one column is Year...
  2. Alan_P

    Excel VBA UserForm - Easier way to Hide/Show TextBoxes/Labels based on ComboBox Selection?

    Hi All, Bascially I have created a UserForm that has a ComboBox and depending on the number selected I want it to show that number of Labels/TextBoxes... so if I select "0" nothing is shown, if I select "1" one set of Labels/TextBoxes is shown, select "2" and two sets of Labels/TextBoxes are...
  3. M

    Prevent duplicate selections across multiple comboboxes

    I'm trying to create a spreadsheet where the user makes multiple selections; there will possibly be thirty or more comboboxes, each with calling up the same named range. I'm looking to prevent the user from being able to make the same selection in more than one combobox, however I'm really not...
  4. D

    Make a selection in a ComboBox based on a specific cell input

    I'm trying to do this without using VBA. I have 3 combo boxes with a list of 10 available selection items(the 3 combo boxes have the same list of 10 items). I want them to default to a specific selection when a value is entered in Cell A1. I want to save some time for the user, so that the user...
  5. G

    Save & Send userform-data to a specific person based on Combobox name in the list

    Good morning All, I made a userform containing a couple of textboxes/comboboxes etc... is it possible to send to a specific person in the combobox list an outlook-email (silently) containing the userform data ? Example: if i select the name "Gabriel" from the combobox and i click the Send...
  6. D

    Display time in Combobox

    I have a Combobox that displays time values. My cells on the worksheet is set to custom as h:mm and the values are 24/hr clock. I have to convert the values to format(combobox1.value, "h:mm"). This works except that when I select "6:00:00 am" on the dropdown, is displayed as "0:25" and...
  7. A

    Retrieving Combobox Value

    I'm working on a userform with a combobox styled as a drop down combo. I am filling this combobox with values upon UserForm_Initialize. I want the user to be able to make a selection from the dropdown or enter their own value. The problem I am having is when a user enters their own value I am...
  8. D

    Combobox entires

    I have a combobox with listfillrange of three columns of data (sheet2!A1:C20). ColumnA ColumnB ColumnC -------- -------- -------- Data1 Data2 Data3 ... I know if I do ComboBox1.Value --> this will get me Data1. How can I get the value in ColumnB, Data2?
  9. S

    VBA Dropdown propblems

    I am using several dropdowns on my user form to display list items from a dynamic range using the following: Private Sub UserForm_Initialize() ComboBox1.Rowsource = "dynamicrange" End Sub The list works but it will not let me select the first item on the list. This is problems something...
  10. M

    VBA form Date format

    Does anyone know how to the change the date format in a ComboBox on a form when the dates are entered from a worksheets range into an array. I've tried the format command but it doesn't work in my syntax. The code which enters the dates is as follows: Public Sub cboCDate_Enter() ' Routine...
  11. girapas

    Pass a value from a combobox to a sub

    From a sub, say subA, I load a userform with a combo box, say cboA. I want to pass the value of the cboA selection to a variable (say x) to use it in subA.

This Week's Hot Topics

We've detected that you are using an adblocker.

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
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 "".
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.
Go back