dropdown

Hi all, Created an ActiveX ComboBox with search suggestions that automatically refilters ("shrinks") as the user types (KeyUp event). The ComboBox is "floating" and sizes/positions itself depending on whether or not the ActiveCell intersects certain rows/columns. I've noticed that whenever the...

I am creating a dependent drop down where the drop down itself is located on the first tab of the sheet and the data that includes the dropdown options is on another tab. When the drop down and the data are on different tabs, I get the following error when entering the index match function into...

I am in Excel v2016 on Win11... I am preparing a book catalog for my simple purpose of data entry, that is entry of bibliographic metadata (the usual title, author, etc.). I have 9 column fields named with an alphanumeric 'code', a simple combination of a number (1-9) and 2 lowercase letters...

Hi All, I currently have a budget sheet where when i select a customer from a drop down list, the ratio will calculate and change the result to show the overall profit as per selected customer. The client was created by a data validation list and the ratio through a xlookup. The ratio in...

Hello, so first of all - this is not about dependent dropdown lists - The dropdown lists in my excel file are already dependent from each other. What I would like to know if it's possible to automatically change what is set in one dropdown when changing something in an other one. So for...

Hello, I've searched this forum and many examples on google of a formula or data validation list formula that might accomplish my needs to no avail. I'm looking to populate a dropdown box's list of values from a table on another sheet that matches a cell value. I've seen many examples of the...

Hi, I am a total beginner in VBA. I have an excel with two sheets as "form" and "database" (actually more but others are not relevant). In the Form; 1) Users type their username, password, and select the week. 2) In the orange part, users type other stuff (to all 3 rows). 3) When submitted...

Hi, I have an excel with two sheets as "form" and "database". In the form sheet, various users type their input into rows 9-12, and before posting each user selects his/her username, type password, and select week in Cell F7 (which is a dropdown where options are Week 1, Week 2, Week 3, etc.)...

Hi, I have a spreadsheet containing a list of products and Promotions. Each product can have multiple promotions, and one promotion can be found in different products (many-to-many). This spreadsheet is updated constantly. I created a UserForm with a dropdown list containing unique products...

Hi! I've just been Googling excel forums trying to find a way to do this. I just want to make a cell auto-populate a body of text based on a dropdown menu selection. I know how to do that, though... However, I want to be able to EDIT the text that populates...and I DON'T know how to do that...

Hi all, I am working on a project that uses a form I have created in Excel to populate Rich Text Formats in a word document in order to streamline report generations. I have almost completed the project but I have ran into a problem I can't seem to figure out. I am fairly new to the VBA...

got a code that allows you to select multiple values from a list. The below code works with 2 defined name sets (called "MY_RANGE" & MY_RANGE2") BUT stops when i add "MY_RANGE3" Private Sub Worksheet_Change(ByVal Target As Range) ------ Dim OldVal As String Dim NewVal As String...

Hi all! Your help with this would be greatly appreciated. I have 2 dropdown lists using the same source. When the value in either List 1 or List 2 is changed via the dropdown, I want the other to change to match. I've got it working for one using the below VBA code, however, if I repeat the...

Similar to Drop Down thread: Drop Down (would simplify that one if this is possible) Below is an example of what I'm looking at. Seeking a non macro solution to have drop down display as shown, but enters only the code portion, so if A: Apple was selected in C3 it would return...

I have the following table: Brand Type ProductName Brand A 100 Product_01 Brand A 100 Product_02 Brand A 200 Product_03 Brand A 200 Product_04 Brand A 300 Product_05 Brand A 300 Product_06 Brand B 100 Product_07 Brand B 100 Product_08 Brand B 200 Product_09 Brand B 200...

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

Howdy y’all, I am working on a sheet that will ultimately have a lot of non-Excel-savvy folks using it. For that reason, I’ve been asked to protect the sheet to limit how much can be edited. As such, I don’t want to allow “edit objects” when protecting because there are several shapes/text...

Can Macros be used to go through a lists in one worksheet (A) to change four dropdowns on another worksheet (B)? Dropdowns 3 and 4 are dependent on number 2, and the number of rows on worksheet A can be over 100 at times. New to VBA and coding and literally do not know if it can be done and...

Dear MrExcel-Community, once again an dependent dropdown question, but I haven't seen a solution (no VBA) for my problem. I've seen a couple of approaches putting values into separate ranges and refering then with INDIRET in data validation, but vor some reason I require the format you see in...

I'm pretty much self-taught on Excel, and I'm really having trouble with this... I have two worksheets in my spreadsheet, the first is Labour Tracking, the second Data. My Data worksheet has a list of seven employees in Column A and their corresponding wage in Column B. The number of...