dropdown box help

Hello, Relatively new to the VBA function. Working on building a checklist that automatically shows and hides specific rows based on the option selected from the dropdown. The Dropdown options: "BOV, Off Market Flyer" After searching a few forums below is the code: --------------- Private...

I am trying to find the correct formula for C2 to pull the corresponding payment amount based on the dropdown selected. For example, if "Troubadour" is selected, a corresponding "$100.00" shows up in D2.

Hi All, I really need your favor today So there's this task on my workplace that i have to do it manually and i don't wanna do it manually. I browsed youtube and landed on WiseOwlTutorials and i found one of the video that taught me how to choose from dropdown area on a website...

Hello, I have a question regarding how to hide multiple sheets based on a user's selection from a drop down list. My spreadsheet has around 60 tabs (the sample only shows 30) and only 15-30 of these will be in use for a project. I would like the user to be able to use the drop down list to...

Hello All, I currently have a spreadsheet that acts like a call log (Sheet1)(Call Log). In one of the cells I have a drop down menu that allows for a "yes" or "no" answer. I'd like to create a code that when the answer is "yes" a pop box appears with another drop down menu with 3 choices (let's...

I have several data validation dropdown lists [not combo boxes from the developer tab] that have more than 12 items in them. Is it possible to edit the list's format so they display more items in the list when the dropdown is clicked?

Good Morning, I hope that this finds you all well. I am working on a project where I want to create a drop down in the cells so that users only can select one value from a pre-defined list. What I would like to do if possible is since the value that will be stored is a code, in the menu I...

Hi all, I'm in need of a Check Box in Drop down list for multiple selection. The code which i had is given below. The disadvantages of the given code was duplication and unable to edit the selection. Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As...

Hello, I am sure this is a quick fix but for the life me I can't work it out! I am creating a planner with all months going along Row 1. I want to create a drop down so when I select e.g. March it will take me to the month March on my spreadsheet. It is going to be a rather long spreadsheet...

Hi there, I wonder if I might find help here, From F9:F325 I have cells with data validation '=IF(L9,DropdownRange,E9)' to '=IF(L325,DropdownRange,E325)', which works fine. I would like to click a button to reset every cell in F9:F325 to the first (and only) item in the dropdown when the...

*I’m very new to VB, so I apologise in advance! I’ve created my first userform for excel, want participants to enter their data, click ‘submit’ and excel will store the data on one of the sheets. Made drop down lists with a combo box, but when the user form opens automatically with the excel...

Hey Guys, I'm running macros off a checkbox that hides a certain number of rows, but when the rows are being shown again, all the drop down boxes are bunched at the top of the range. Here's my VBA code so you can understand what's going on. Sub CheckBox1696_Click() Dim mode As Boolean...

Hey! I'm having some issues with a macro to list all sheets with a workbook. The workbook is specified in another dropdown. I'm not sure how to reference another dropdown. I want the dropdown WorksheetsDD to populate once the workbook is specified in the dropdown WorkbooksDD. This is what I...

Hello board members, After performing work with a client I want to perform some sort of "post-work" cost calculation to determine if my prices are right. If I have a list of products in tab 1 with purchase price & sales price, how can I address those in tab 2 (using a drop down) I have...

I have a dropdown box which I want to use to populate data into about 10 different cells on the top of a spreadsheet. There is a lot more data on the spreadsheet that I do not want to change with the dropdown box, this data will also feed into other sheets in the workbook.

Greetings, Hi, & Hello, Many thanks to all of you who heave helped me get to this point in my project. I have one last hurdle to clear involving a UI. It has 5 buttons (including the cancel). Basically it has a dropdown for "Department" that when selected populates the appropriate products...

I have a table consisting of months across row 4 and material usage in columns C-AQ. On a separate sheet, I have a dropdown box with the months. What I'm trying to do is when I select a month, all the data for usage changes depending on the months. On a sheet named Rolling Sums, a Table that...

Hi there, Here is the issue. Cell A1 = dropdown list - number of choices from 1 to 6 Cell A2 = Choice 1 dropdown list Cell A3 = Choice 2 dropdown list Cell A4 = Choice 3 dropdown list Cell A5 = Choice 4 dropdown list Cell A6 = Choice 5 dropdown list Cell A7 = Choice 6 dropdown list My...

Hi, I've encountered a very frustrating situation after conquering what I thought had been the hard part of my project. I spent a good part of today looking around on Google and this forum in search of a solution without having any success, so I'm hoping someone can give me a hand! What I'm...

Hi Guys I am trying to create about 150 dropdown boxes in a column. All of the boxes will have the same cell input link but the output link will be different for each one. Is there a way to get excel to understand that the output will be different rather than formatting the control on each box...