How to Define Combobox' Variables Without Recording Them Into Excel Sheet?

I have this report formatting tool development task and i want to add my userform some comboboxes. When i searched for how to use them on internet, i always saw them, they get their values from an excel sheet. My file already contains 2 sheets and i don't want it to have more. Is it possible to store combobox's values in the code?

http://www.contextures.com/Excel-VBA...Box-Lists.html

Originally Posted by Norie

Yes it is possible.

Whether it's practical or not depends on what data you want to populate the comboboxes with.

Well. Since i'm gonna put only numbers between 1-5 in my combobox, i found riddiculous to open another sheet for storing values.

BTW i figured out how to do it

Please Login or Register  to view this content.