Posts by Tommaso

    Hi everyone:

    I'm using a VBA code for a dropdown list with multiple options in Excel, but when I enter text manually in a cell that already contains one or more selected options, the code duplicates the previous selections and then adding the new text. For example, if I select "Option 1" and "Option 2" from the dropdown list, the cell displays "Option 1, Option 2". However, if I then type "text" in the same cell and click on another cell, the cell displays "Option 1, Option 2, Option 1, Option 2, text".

    I'd like to modify the code to prevent this behavior and maintaining the selections Option 1, Option 2 with the new text when the cell is edited manually. Here's the current code I'm using:

    In respect to the forum rules, I wanted to mention that I also posted the same question in another forum a few days ago, but have not received an answer there. Here is the link to that post: Prevent VBA from duplicating dropdown list selections when entering manual text. (

    Can anyone help me modify this code to achieve the desired behavior? Thanks in advance for your help!


    I am looking for a way to automate the process of creating a new page in a specific section of OneNote and pasting content from Excel into it. After some research, I found a VBA code that seems to do the job. Here's the code:

    However, I am running into an issue where the code directs me to OneNote, but not to the specific section that I want to create the new page in. Instead, it sometimes takes me to a random section or the one that is already opened in the notebook. Could you please advise me on how to modify the code to ensure that it directs me to the correct section in my OneNote notebook?

    Thank you!

    Best regards,