comboboxes

  1. J

    Lookup values from two combobox on a userform

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

    Multiple ComboBoxes based on same dynamic Data- Help.

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

    Error when Dynamic Names Range has zero values

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

    Add items to Userform Combobox based on Listbox values

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

    How to loop through Userform ComboBoxes and perform actions

    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 =...
  6. sharky12345

    Evaluate multiple combobox values

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

    Linking 2 comboboxes Column A and Column F

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

    How to duplicate a column containing VBA code

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

    Duplicate declaration in current scope

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

    Excel VBA userform 3 dependent comboboxes

    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...
  11. kelly mort

    selection in comboboxes based on criteria

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

    combobox value depends on other combobox

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

    Display full text of selected dynamic combobox in textbox

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

    Text boxes populating from Combo box

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

    Help with Userform ComboBoxes

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

    Creating Autocomplete Comboboxes with dynamic lists

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

    Any way to change the annoying way comboboxes behave?

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

    Combobox ListFillRange

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

    UserForm outputs to cells in a series of rows

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

    How to populate comboboxes with range from a different worksheet?

    I wonder if anyone can help me. I'm trying to load the comboboxes with data from a different worksheet. However, no matter what code I try it only loads from the active sheet. Here's an example of one of the subs that I tried. Any help would be greatly appreciated! Private Sub...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top