Public Variables and Combo Box Usage
 

I'm very new to VBA and I have been trying to figure out 2 issues. The
more you can explain and/or show to me, the better for my knowledge

- I have multiple forms to pull multiple reports or perform functions
and several need to use 2 Combo Boxes

For example:
-In Column B I have a list of people
-In Column C I have a list of projects
-In Column D I have a list of accounts
-In Column E I have a list of Team assignments


My issues that I am trying to figure out:

1) Define a list that I can call on in multiple combo boxes in
multiple modules. (ie. Form1. Combobox1 = "List of People" and
form5.combox3 = "List of People"

2)In some of the forms I need Combobox1 to show list of people ; Once
that is selected, combobox 2 shows the projects associated with that
person.