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

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top