Hello, I'm fairly new to excel, just getting my feet wet with VB as well.
I'm trying to do the following with the least amount of code and/or copy/pasting as possible. I'm having trouble figuring out the logic to it.
The setup:
I have multiple cells on my presentation page.
G36 down to G43.
L36 down to L43.
Q36 down to Q43.
Next to these cells I have 2 combo boxes. One is to choose a main category (not dynamic) and the other is to choose a sub category (also not dynamic).
The main combobox determines which category you choose, and the second combobox breaks that category down. So, for each 10 main categories I have, there are 18 sub-categories.
I'm allowing the user to write their own notes in the cells I listed above. Each sub-category for each main category will have their own notes.
Function wise, when a user goes to a different category, the cells will update to the notes they previously wrote.
I figured I'd have a hidden sheet to store the values, then pull them up depending on which listindexes are selected in the comboboxes. Problem is, I'm not really sure how to efficiently do this. The hidden page's formatting can be whatever (they won't see it).
How can I do this correctly? Thanks.
Bookmarks