ComboBox issues with Displaying AddItems

[dversion]

So I have scrolled pages of suggestions for an answer to my dilemma, but have yet to come across a solution that works for my problem. I am very new to VBA and have little knowledge of coding in general, but moderate excel experience with functions, formulas, etc.

Background - I'm trying to design a workbook for a company to easily be able to see the effects of Best, Expected, and Worst Case Revenue projections with the flexibility to adjust wages, purchases, etc. to be able to quickly plan for changes. In designing the workbook, I want to use a Combo box as a drop down on the home page to flip between Best, Expected, and Worst case scenarios. Ideally I'd like to link the drop down options to a second worksheet to directly pull in the monthly projections for each scenario, but a simple drop down selection that I can link to a cell on the home sheet can also work in conjunction with an IF statement.

What I have thus far is -
ComboBox with ActiveX

Please Login or Register  to view this content.

The Choose Scenario item I will zero out in the budget forcing a choice of the revenue projections, but when I save and re-open Excel the drop down box is empty. I looked at the fill range, but each item is in a separate location on sheet2. I would like to avoid creating a list in excel to preserve the print ability of the schedule.

As I said, I can make due with a simple drop down box in conjunction with an IF statement, even though I'd ultimately like to learn the true programming side eventually.

Thanks in advance for the help.

[romperstomper]

You'd be better off with a drop down in my opinion but if you must use an activex control I suggest you populate it from the Workbook_open event rather than the combobox's change event.

[dversion]

I changed my my event to Workbook_Open as suggested, but the drop down box still appears empty on a restart.

[romperstomper]

The Workbook_Open code must be in the ThisWorkbook module of your workbook.

[dversion]

Thank you for the help, it worked.

[Cutter]

Hello dversion, and welcome to the forum.
Firstly: Please notice that I have added code tags to your original post. The forum rules require them so please keep that in mind for your future threads. Thanks.

Here's the rule:

RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Secondly: Based on your last post I'll mark your thread as SOLVED. The forum rules also require this so please keep that in mind, also, for any future threads.

Here's the method:

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save