comboboxes

Hi All, First of all thanks in advance for helping me on this. I have created a Userform that has a few simple elements in it. 1. ComboBox1 2. ComboBox2 3. TextBox1 4. Okay, clear and close buttons From ComboBox 1 you select the job role. From ComboBox 2 you select the relevant file you want...

Hi Im trying to lookup two values that come from two comboboxes of a userform and the result to appear in a textbox The values of the comboboxes are related to two different name ranges on my sheet 2 and the table array for the lookup formula is in the same sheet (sheet2) I want that a button...

Good day, I'm developing an order form for my workplace. I initially used DropDowns (Data Validation Method); however, upon trailing the form, our staff found it hard to scroll through an inventory list of 400 items. Last night I searched and found an answer to searchable lists: ActiveXComboBox...

I'm using this to populate a number of Comboboxes on a Userform; For i = 1 To 24 Set ws = Worksheets("ResourcesNew") If Me.Controls("ComboStaff" & i).Value <> "" Then Else Me.Controls("ComboStaff" & i).List = ws.Range("NewAvailableStaff").Value End If Next i The idea is that as each item is...

I have a Listbox on a Userform which is populated like this; ListBox1.RowSource = Range(Sheet4.Range("Z2"), Sheet4.Range("Z65536").End(xlUp)).Address(, , , True) What I need to do is populate a range of Comboboxes with values from that Listbox - so if a value disappears from the Listbox it's...

I am struggling with VBA code to loop through ComboBoxes on a userform and perform actions. The userform has other controls on it besides ComboBoxes. I've tried: Private Sub UserForm_Initialize() Dim ctrl As Control numTemplates =...

Can someone help me with this please, it's one area of VBA which I have never been able to truly understand no matter how hard I try; I have 3 Comboboxes on a Userform, named ComboES1, 2 and 3. I want a routine to run when the Comboboxes are changed to do other bits in the following...

I have 2 comboboxes that I want to link Column A is Dates and Column F is the data. For instance when I click on combobox2 A2 it must show combobox3 F2 is value. I have tried the following code but it does not work -I have set the rowsources correctly as it shows both fields but when selecting...

I am creating a note-taking worksheet for which the design is a column for the user to note certain features of an item. The column contains several ActiveX comboboxes. I have learned how to insert vba code to allow the user to key into and out of the comboboxes as they move down the column...

I created a userform with 10 comboboxes 1 - 10 which populate with part numbers, with corresponding txt_qty boxes 1 - 10 which populate with ordeer quantities. I want to search on the part number in "ComboBox1" and then store the quantity from txt_Qty1 into a cell in the column named "Order...

I have created a userform that uses 3 dependent comboboxes to calculate the price of a tour. Once I have filtered through the levels, I am then trying to pull in that tour's specific data such as prices. The program I have works though only up to a point. After I increase the number of objects...

Hello All, I have two comboboxes combobox1 and combobox2 and wants to select in the second one as below: when i select the first item in the combobox1, select the first item in the combobox2. When i select second item in cmb1, select the second item in cmb2 and so on. Thanks. Kelly

as simple as this , can i use the same indirect function on a combobox on a userform and how i have two comboboxes 1+2 and a prenamed lists

Hello again folks, I have a quick question. I currently have a multipage userform that populates dynamic comboboxes within a frame on a button click. I was thinking about having a textbox on the same page that will display the full text of the active combobox in the textbox when it is clicked...

Hello, I have a code that mostly works. The only problem i am having is when the text boxes populate, they always populate the last item in my list, and not what i am clicking on. Any help would be greatly appreciated. Private Sub ComboBox2_Click() Dim LR As Long Dim fRng As Range...

Hello - I have setup a userform with 6 different combo boxes for users to make selections from and a Submit button. I have macros setup for each of the comboboxes similar to what I am showing here below. Essentially, each combobox has choices from 1-4, and then those choices are linked to an...

I use Excel 2007 and tried creating Auto Complete combo boxes using the example shown here http://www.contextures.com/xlDataVal10.html. Now in the example if i type "ju" and click on the drop down I should have the value "june" selected but that does not happen but according to the example this...

Hi All, You know with comboboxes on userforms... when you click on the arrow to show the dropdown list... if you move to the list too quickly (seems to be before the shadow has appeared under the list) then the list disappears and whatever your mouse happens to be hovering over is selected...

Is it possible to use the Combobox ListFillRange to list values from two groups of cells? For example, in column 'A', I have the values, 1,2,3; and in Column 'B', I have the values, A, B, C. I want to list the values in column 'A' along with the value of say, B, in Column 'B'...

I wonder if anyone can help me. I've created a userform with cascading comboboxes and other fields and when completed the userform populates cells B3:H3. The problem that I'm running into is that I need the form to populate the next row with the next entry of information. For example, the...