1. B

    Macro To Change Drop Down Company Name and Save as PDF

    Hello All, Trying to work out a process to automatically save chargeback detail for a group of vendors based on a drop down filter. It is based on drop down filter because one vendor can return up to 500 lines. At every change in vendor, save what is visibly showing as a PDF. Sometimes what...
  2. Thumper007

    Formatting on a list Dropdown

    Good Afternoon all, I have a list that contains 3 options. Watch option is a statement. I want to highlight a specific word in each statement and then on another tab, be able to select the statement from a dropdown and have the statement come over with the word still highlighted. Is this possible?
  3. I

    Duplicate data entries from dropdown menus

    Hello, I'm working on a personal project and I have the following problem: I have drop down menus in 13 rows of one column.. These dropdown menus have some overlapping values and some distinct values (on purpose). For example, Row 1 dropdown might have (1, 2, 3, 6, 7), Row 2 (2, 4, 5, 6), Row 3...
  4. M

    Multiple dropdown based on cell value.

    I'm trying to write a macro that with Dependent Multiple dropdown based on Column cell respectively and below mentioned fixed content in sheet2 & in Sheet1 i need the data based on cell value for till nrows. Sample data mentioned below Mname mvalue mtext mid mextn abc 1 xyz q1 po1 abc 2...
  5. P

    Combox is slow and floats in other sheets

    Hi, I used a combox that fills as you type in a project with a long list. I used this option instead of the regular dropbox, because at time we have more than 1000 options to choose from, and it easier for the user to start typing and selecting. The only issue I am having with the combox, is...
  6. D

    Using IF AND and COUNTIF in one formula

    I have 6 dropdowns with the same 30+ options to choose from in each. 10 of those options have similar attributes and I want to advise the user if they pick 4 out of 6 of these when filling in the 6 dropdowns. I have a cell off to the side of these options that will display this message. I got...
  7. S

    Userform Combibox (dropdown) box populating

    Good Morning, I've got a data array, which my userform combibox/dropdown menu references. I have 100 available "slots" for data input in the array, but I don't use all of them. The initialize code (below) works well for the combibox to populate it. However, being as I only use about 20 of...
  8. L

    select a value from dropdown list via EXCEL VBA

    i want to select a value from dropdown list and have tried below code, but can't work. please take a look: <select name="fldcusval" nchange="fnSetBankName();fnSetCurrencyList()fnGetCustomer();;displayDetails (this);">..</selec> code ie.Document.getElementsByName("fldcustval").Foucs...
  9. B

    Drop Down List Pulling From Range From Different Workbook

    Is there a simple way to have dropdown look to a range in a separate workbook?
  10. E

    Using SUMPRODUCT with multiple dropdown menus

    Hi, all! I've got a calendar-style sheet (sheet 3) that I'm pulling data from, and I've got the categories in 2 different dropdown menus on a second sheet (sheet 4). I'm trying to get a cell to add up all of the occurrences of certain text within the calendar. I've figured out how to...
  11. K

    VBA dropdown list

    Hello everyone, I want to add a dropdown list to a selection of cells. My code is adding a dropdown list to the cell but the list contains all the option as one. Meaning that instead of giving the chance to choose either option 1, option 2 or option 3 it gives only one option called "option 1...
  12. J

    Dropdown in vba userform

    how to avoid a user to input text in my dropdown.. all I want is to let the user choose on my items in dropdown list and avoid the user to input text that are not belong to my items in dropdown list
  13. B

    VBA to replace vlookup or countIf due to extensive llist

    Hi, I created comboboxes with dropdown lists I presently have formulas that searches through a long list (7000) of names and then once found information is auto-populated in identified cells This is the search mechanism I presently have in place In Column K...
  14. countryfan_nt

    VBA to hide ribbon, done, but now vaidation deactivated

    Hello friends, Hope all is well! thanks to you, I succeeded in hiding the ribbon by using the below line. problem now: validation dropdown menu is not active. if I remove the below line the validation works. please help me remove the ribbon and allow the validation's dropdown menus to work...
  15. C

    Dropdown menus dependent on another cell being <8.0 or >8.0

    Hello - I've created a timesheet for my employees in Excel. I'd like there to be one particular dropdown menu that shows if the total hours for a day are less than 8.0, and another dropdown to show if the hours are more than 8.0. I know how to do dependent lists, but not how to make a list...
  16. J

    Keep color coded name in dropdown list

    I've got a List with player names and whether they shoot right or left (NHL). The players names who shoot right are colored red. When I use the dropdown list I want the red color to remain with the name. How do I accomplish this? Thanks
  17. G

    Dependent drop menu with formula

    I'm trying to create an excel sheet with 4 columns. Column A will have a dropdown list of choices. Column B will have a dropdown list of either yes or no. Column C will be the weight you need to enter. Column D will show the value after it auto calculate. On a separate tab, there would be...
  18. T

    Searchable dropdown list in multiple cells from one source

    Hi, I'm looking to create a searchable dropdown list in each cell of a calendar, for 10 classes, roughly 2000 dropdowns. At the moment I have non-searchable dropdowns in each cell, which means scrolling a long list of lessons to find the correct one - it would be much easier if I could type...
  19. U

    Macro/VBA to insert a comment mandatory when selecting a dropdown option

    Is there a macro or vba code i can use so that when cell C6 dropdown is selected, a message box appears for the user to insert a comment mandatory? I would like to use this for multiple cells i.e. cell C6 dropdown 'Resource' is selected, message box appears saying 'Insert Comment'...user...
  20. C

    VBA If/Then with formula and locks/unlocks cell

    I am new to writing macros and am struggling with this one. I would like the following to happen automatically: If Cell "C8" equals "NEW" then unlock Cell "F8" and allow someone to type in any value in Cell "F8". If Cell "C8" does NOT equal "NEW" then lock Cell "F8" and run this formula...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...