combo

  1. S

    creating userform enteries from drop down menus

    Afternoon all Sorry struggling with this one if someone can help me please I have a userform (userform1) that uses a combo box to look at a named table on my sheet IE "Coolant Type" I have this working fine by using Me.ComboBox1.List = Range("Coolant").Value (stored in AW4 - AW16) the...
  2. I

    Userform Combo boxes not linking to multiple different sheets

    Beginner vba user here on Excel 2013. I am creating a user form with two different combo boxes that draw from two different sheets within the same workbook. I have a last row function included for each combo box as the ranges may change from time to time. Here is my code: Sub...
  3. S

    Combo Box to Filter Rows Based on Value in Selected Month

    Hello, I have an Excel Table with columns labeled for the months of the year. Each row contains an "x" in one or more month columns. I would like to use a combo box to list the months and when user chooses a month from the combo box the table is filtered to show only rows that contain an...
  4. C

    Data from ComboBox in TextBox via DB Query

    OK, I'd love to say I've had a go at this but to honest I don't even know where to start with the text boxes. I have a combo box populating it's items from an Access database, This i'm doing using getrows and it populates fine. The problem I have now is with the text boxes. Each row in the...
  5. R

    Linking Comboboxes to their corresponding cell

    Hello, I am trying to link a large number of combo boxes to their corresponding cell. The Combo Boxes are in cells K2:K300, and I need a quick way to link them all to their current cell. I know how to do it manually, but manually linking 299 cells would take all day. :/ Any help would be...
  6. J

    dynamic combo box in a userform

    hi there, im still new but i learned a bunch of tricks on vba that help a lot. now i have a problem as follow, i have 11 pre-named ranges on sheet1, first one have classes and its name is "expclass" and it contains 10 items ( class1, class2, class3, to class10) and the other 10 pre-named...
  7. B

    Extract data into separate cells

    Hello. I have data in a cell that I need to extract into seperate cells. Here's the example: 14 = Street RCA Combo #203: Task BG0178 15 = Street RCA Combo #204: Task BG0018 16 = Street RCA Combo #205: Task BG0020 17 = Street RCA Combo #206: Task BG0022 18 = Street RCA Combo #207: Task BG0348...
  8. P

    Multiple Cells choose from 1 combo box

    Hi all, I think I am trying to do the impossible. I have to create a quote sheet that has multiple lines all choosing from the same equipment list. I know I could use data validation on multiple lines but it doesnt allow to autofill or format the text. My ideal scenario is to create one floating...
  9. J

    Help using 2 combo boxes to find a value.

    Hey guys I'm hoping someone can help me, it seems I am over complicating something that is probably a lot simpler than it seems. I have a price calculator I am currently working on, in which you use 2 combo boxes to then vlookup the 'category' they fall into. for example purposes I have the...
  10. X

    Referencing Comboboxes by Name

    Hi guys, Long time viewer, first time poster. I have several comboboxes that I will be using on a single worksheet and I need to assign (and read) their values. Would naming the comboboxes be the best route? I am coding several subs within one module, will I be able to reference the...
  11. J

    Combo box question

    Hello again, Now I have this problem. I want to create 2 combo boxes in sheet1. The first will have the names of the sheets i am using, and the second will have some data depending on the Sheet the first one indicated. For example the first CB will have the values (sheet1, sheet2...
  12. E

    userform help ... combobox times textbox = emptyrow

    hello im working on a userform in excel i would like to have a combobox that has the words "yes" and "no" then after the user picks "yes" then it would take the textbox187.value * 4 (it needs to times it by 4) then it puts the value in emptyrow, 26 ...... OR if the user picks "no" then it would...
  13. R

    Combo box showing values based on another combo box selection

    Hi Without using VBA, I would like to have a Combo box showing values based on another combo box selection. E.G. The 1st box would have a list of Countries and when Country was selected, then the 2nd Combo box would show the appropiate Cities for that Country only. I have tried listing each...
  14. L

    contr onol source from combo

    Hi Guys Happy New Year to Y'all I hope this would be the simplest Q for most of you. I have a combobox containing the field names of a table called Main Also, I have a report called xyz which only has one field. All I was whatever field name user selects in the combo, report displays the...
  15. W

    vb 3 combos containing same items - how to remove selected item form other 2 combos?

    I have 3 combos on a excel form. Each contains identical items. When combo 1 is selected I want that item to disappear from combos 2 and 3 and so on. Have tried combo2.removeitem(combo1.ListIndex) but the lists get reindexed all the time so soon become out of sync with eachother. So option A...
  16. O

    ActiveX Combo missing Slider, XL ver 2010

    I'm using Excel 2010. I'm also a first-time poster on this forum, so I may amend or post clarification, later, if needed. And I welcome comments on forum protocol or requirements. I use VBA code extensively in the application. There is a "trigger" (on the down arrow of the Combo) to a...
  17. L

    enter data in combo box without clicking on box

    Hi: On my worksheet (Excel 2007), the user will be entering data in both cells and combo boxes. Each time he enters info in a cell, he hits enter and the cursor moves to the next cell; however, if there is a combo box positioned over a cell, I would like the cursor to move into the combo box in...
  18. O

    Auto complete combobox on sheet

    I would like to ask if any on knows wher I can get some VBA to Auto complete combobox on sheet, but what I will ask is, is it possible and if I have to use ActiveX how do I do that? Excel 2003 XP
  19. B

    Colors in Combo box

    I have a forms combo box that obtains its data from a range on another sheet. The text on the other sheet may be formatted with different colors, but the colors are not showing up in the combo box. Can I make them cary the formats in the source cells? Thanks.
  20. S

    ms database to excel cells

    Hello All I am filling sheet 1 with a table that has Manufacturer, PartNumber & Price and headings. On sheet 2 i want to have about 20 rows each having the following: - Manufacturer Part Number Price Qty Cost The manufacturer and part number cells would all need to be some form of drop...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top