Populate a list in a sheet through a userform without a range

    Hello,


    I was wondering if something was possible.


    If I make a list on a sheet in cel B3 through the option " Data Validation", and fill it for example with the options "test;test1;test2"
    would it be possible to make userform that reads the list options in cell B3, show them in the userform and be able to add or remove an option?
    So if you want to remove the option "test2" you can do that from within the userform, same if you want to add a option.


    I know you can have a reference to a range of cells, but I want to know if it is possible?


    Thank you.

    You need to make a List of the options for the data validation drop-down on a separate sheet, make it a Dynamic Named Range.


    Then use that list for the data validation.


    You can then have a user form that imports that list when it initializes and have controls on the user form to add, remove or edit items in the list, then a command button to write the changed list back to the Dynamic Named Range.


    The data validation drop-down will then be the modified list.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    [USER="33159"]KjBox[/USER] Thanks for your answer.
    So Im guessing I can't do it without using cells. I have to have a reference from a sheet.


    Again thank you.

    That is the best method, the sheet you use for the list(s) can be hidden.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login