drop down box

Hello everyone its been a while since I asked for help but I am trying to create a dynamic list, maybe I should use a table, on one worksheet (something that can grow or shrink in # of rows over time) and have that dynamic list available on several other worksheets in dropdowns so that when an...

Hello MrExcel community! I am in need of some assistance. I am trying to implement a new staff directory for Special Education staff assigned to schools for the very large school district I am employed by. I have created a data worksheet (Master) with all 180 schools and up to 13 staff...

I have created a file which is having a drop down list of names vlookup on Sheet1 with another sheet. Hence, one name is selected the values will be displayed on the Sheet1 as vlookup arranged. I need a VBA for that dropdown list having cell (B4), Hence it should be split into multiple...

Hi, I have put together a table with roof pitch (0.5-30 deg) along the top and roof area (5-800m2) down the side, these are my two variables that I would like to select in two separate drop down menus. Based on the selection of roof pitch and roof area selected in these two drop down menus, I...

My problem is coding a drop-down list that selects the worksheet that needs to be printed. The worksheet information to be printed reside in the column "C". In this example, I am showing the dropdown the "vv" selection and I am printing the "sheet1". I see that the formatting is not working in...

I am trying to create a master sheet where all the information associated with each name is entered. It is in a table and each name is repeated in 4 rows and then it goes to the next name and so on. Each name has 4 (1,2,3,4) different ID#'s that indicates the depth where the sample was taken. I...

Hi I have an Excel (2016, O365) sheet with a blank drop down box that I just can't delete. I have tried all the suggestions listed on this forum and others but the drop down box still remains. They appear in the selection box, but above a black line. Are items listed above the black line...

I am using Excel 2010, and have two dropdown boxes. Everything is set the same in both, but with different named ranges as the dropdown selections. The problem is one box allows users to add additional text after the selection. The other dropdown box does not - it gives an error message when...

Scouring through the internet, watched many videos, and read a few other articles, (one which i thought would help but they were using Open Office, and I didn't feel like downloading it just to view 1 file, and my luck it not be helpful) anyways... I have 4 sheets. Sheet 1 is my...

I have a dropdown that gets its reference indirectly from another cell. The referenced list is a table column that will contain any digit from 1 to 9 but not necessarily all of them and some will appear more than once. I can find lots of way to extract those unique values but This would mean...

Good morning, I am currently trying to have timestamps entered into adjacent cells based off the value selected from a drop down box. The drop down box values are: Complete (Company), SME Review, and SME Action These values are in column A, under a title Status in A1. When Complete (Company)...

Hello Everyone, I have this code; Private Sub Workbook_Activate() Dim oSheet As Excel.Worksheet Dim oCmbBox As MSForms.ComboBox Set oCmbBox = ActiveWorkbook.Sheets("cmbSheet").cmbSheet oCmbBox.Clear For Each oSheet In ActiveWorkbook.Sheets oCmbBox.AddItem...

I am trying to change the color of a tab based on the cell value in B5. B5 is a drop down list using data validation that contains four entries: "Flow Rack" , "Workstation" , "Machine Guarding" , and "Other (custom)". A tab is named after each one of these as well. If someone selects...

I am using a drop down list to populate the adjust cells next to it. I am trying to lock the cells that populate based on the drop down. Is there anyway to lock those cells and still have the information change if necessary?

I created this macro to include a Drop Down Box in a worksheet, although I think it is a bit old-fashioned. Any suggestions to make it better? Option Explicit Option Private Module '--------------------------------------------------------------------------------------- ' Module ...

Hi all, Im using excel 2010 with windows 7. I need help with a sheet that I made that is going to be used as an ordering tool for customers. It's very basic; all the possible items that can be ordered are in a searchable drop down list that I made using the combo box and a macro that I found...

Hi, I have an excel file in which cells have drop down menus, created by data validation. I know how to make the lists dynamic, meaning I can change the list behind the drop down menu depending on circumstances. However, I want to make the whole presence of a drop down menu / data validation...

Hi, I do not know VBA, but everywhere I search, it tells me this is a VBA function. I am trying to put an array into the formula bar of a dropdown list, but whenever I hit Ctrl+Shift+Enter, it just takes it as "Enter" and does not add the array brackets. The formula seems to be workin with a...

I'm fairly new to the world of macros but i have managed to set up some simple macros that filter some data by using the "Adavanced Filter" function. This data is filtered to show whether a set of chemical standards are going to expire "within 2 weeks", "within 1 month" etc etc. These have all...

I am trying to develop a rather robust engineering/architectural style hardware schedule using Excel and data validation tables. Due to the numerous options though, I feel that data validation tables will require far more maintenance than the benefit of developing this project. To work as well...