dropdown menu vba

  1. T

    Dropdown list in VBA InputBox

    Hi, Is it possible to get a dropdown list with VBA InputBox? The dropdown list has to refer to the table[column]: "TabelMatriaalinformatie[Materiaal:]" Thank you for you time. A part of the VBA code i have now: Dim Materials As Variant Sheets("Beginblad").Select Materials =...
  2. C

    Dependent Drop Downs in UserForms

    I'm trying to create a userform with dependent drop-down lists in it. I'm trying to populate these lists from various tables that I've got saved in a couple of sheets. I know how to use dependent drop-downs within the spreadsheet, but I can't find anything on how to do it within a userform. The...
  3. C

    Behavior in Dropdown Menu List

    Good day! I would like to ask your help regarding the vba code that I need to enter in making my list automated. What I want is that whenever I select from the dropdown menu, the table will be automatically be filtered without including the blank ones. I was able to attain this, but, an error...
  4. W

    VBA: To run macro based on selected dependent drop down list

    Hi fellow coders, To begin with, I am very new to VBA. Firstly, I want all of these to be incorporated on a popbox menu (similar to a userform). In that form, I want to select a list of options (from multiple drop down lists) and hit a command button to execute based on the selected options...
  5. A

    Help with VBA to protect and unprtec sheet

    Hi, I have a file with the following VBA:</SPAN></SPAN> Private Sub Worksheet_Change(ByVal Target As Range)</SPAN></SPAN> Dim Sheet As Worksheet</SPAN></SPAN> 'I have a dropdown with the following options:</SPAN></SPAN> 'New > 250 but <750</SPAN></SPAN> 'New >750</SPAN></SPAN> 'Existing >250...
  6. B

    tracking numbers input and dropdowns

    I work for a church food bank that calls groups of people. they need a better way to display and track what random group numbers are called and how many families are served every day. im trying to make this easier because they are manuall entering this into notepad on an overhead projector and...
  7. J

    vba changing the selection in a html dropdown menu within a form

    hello all, I am trying to change the selection in a html dropdown menu within a form with vba in order to collect information on the next page. here is what I have at the moment. With appIE ' change page .Document.forms("portfolioView").getElementsByTagName("pv_id") = "2" .Quit...
  8. S

    Dropdown list that updates

    All, I have drop down lists that I use to assign the employees at work to complete certain daily tasks. I am wondering if there is a way for the list to update and eliminate the items I have already assigned from the dropdown menu so that I can see only the tasks not assigned as I progress...
  9. R

    Dropdown menu - VBA copy values

    Dear All, In excel 2003 I have an excel file with two sheets: Sheet 1 contains an input sheet for my users - this sheet is called: "Resource pool", I have several data in the sheet. In column E I have dropdown menues for each cell - The user can determine diffent allocation types. In columns...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top