Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Declare and Set Public variables | Excel Discussion (Misc queries) | |||
public variables | Excel Discussion (Misc queries) | |||
Public variables | Excel Discussion (Misc queries) | |||
Public Variables | Excel Discussion (Misc queries) | |||
Declaring variables in Module vs. Public | Excel Discussion (Misc queries) |