Forms In Excel 1

[Tacone]

I have a Worksheet that has a Form. The Form has two Combo Boxes. The Combo Boxes are loaded from a second Worksheet. When the Update Button is clicked, the data from the second Worksheet is loaded into the two Combo Boxes and the Form is displayed.

I added a third Combo Box to the Form, but I do not know how to load data from the second Worksheet into the new Combo Box. I have looked at everything imaginable and I have looked at a lot of website solutions, but I can not figure this out.

I believe the Combo Boxes are not loaded using VBA, and all of the solutions I have found use that method to load data into the Combo Boxes. When I added the third Combo Box, I expected a question asking where the data should come from, but that did not happen.

Can someone help me with this? It seems like the answer should be easy, but so far I have come up empty.

Thank You for your assistance.

 

[PHV]

Have a look at the RowSource property of the ComboBox object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Tacone]

Wow....That was a quick reply. Thank You.

I found the RowSource somewhere in my wanderings, but it does not seem to be available. When I right click on the Combo Box, the only options are:

Cut
Copy
Delete
Properties
View Code
Align
Make Same Size
Bring Forward
Send Backward

I am looking at the Form in VBA when I perform the Right Click. Should I do this some other way?

 

[PHV]

Display the properties window (F4).

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Tacone]

The RowSource for the first Combo Box is "Territory". I have looked through the VBA code many times, and the only "Territory" I found is the variable that receives the selection from the Combo Box.

The Combo Box receives Columns A, B, and C from the second Worksheet, but there is no "Territory" that I can find that is associated with it.

 

[PHV]

Have a look at the named ranges ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Tacone]

I feel kind of foolish at this point, but I have never really Named Ranges before.

Thank You so much. I spent two days spinning my wheels over this.