combobox value

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

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

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

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

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

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

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

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?

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

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

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.