dropdown menu vba

Hello everyone, I am struck with this problem since yesterday and have been unable to find any solution despite all the web searches. Please help me if it is indeed possible. To better explain the situation: We have multiple templates for different product types (400+). We share these files...

Hi there, I have excel sheet data created with VBA, and simple dropdown menu list to chose different formats. But I would like to have an option to select format and then the line speed for selected format would show on cell on top of it. Is there any VBA code that I could use or a simple...

I have a Table, with 3 column. In picture I showed what I want. I need 3 dropdown list that depend each. List 1= list cul-1 (without duplicate). list 2= everything in Cul-2 related to return of list 1 (without duplicate). list 3= everything in Cul-3 related to return of list 2 (without...

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

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

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

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

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

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

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

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

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