I have a group of cells that I fill with information for the rest of the sheet to work with.
some are just standard cells and that's fine but I have some setup as data validation lists with the in cell dropdown ticked.
how do I input that into the userform to allow me to do the same thing as the data validation list but inside the userform?
or do I have to remove the data validation list and create a listbox?
id like to keep it setup as how it is if I want to manually change something rather than having to open the userform just to change one thing.
some are just standard cells and that's fine but I have some setup as data validation lists with the in cell dropdown ticked.
how do I input that into the userform to allow me to do the same thing as the data validation list but inside the userform?
or do I have to remove the data validation list and create a listbox?
id like to keep it setup as how it is if I want to manually change something rather than having to open the userform just to change one thing.