Display Scenarios Using a drop-down list

Hi, I'm trying to replicate the VBA code for displaying scenarios using a drop-down list that I found on this website: http://www.tvmcalcs.com/blog/comment...rop_down_list/

However, I've not quite been able to get it to work on my worksheet. This is my code:

Please Login or Register  to view this content.

What happens is that the scenario in cell G9 changes, but the changing cells (D23:F24,D26:F27,D29:F33) in my three scenarios do not. Any ideas? I'm just getting into the writing VBA and macros and am stumped at this point.

I've attached my worksheet.

Cheers and thanks in advance for the help!

Tim

Hello judasdac,

The control in the example was a Forms drop down control. Your workbook has a Control Toolbox ComboBox control. The code from the original post won't work with your control. Here is the correct code.

Please Login or Register  to view this content.

How To Save the Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S

projections.xlsm

hi everyone

im trying to link the dropdown box into scenario manager, which ive managed to set up! but cant link the dropdown to the scenarios?? any suggestions or advice appreciated.

thanks very much

Hi everyone,

I've come across a similar problem to judasdac (I've followed the same blog, but have been using Excel 2007). I've Just read your helpful solution above Leith and was wondering if you (or anyone else) could tell me how to correctly write the VBA code for a combo box (form control). I've attached my workbook.

When I run the VBA code it works once when it is run from VBA but it doesn't update when I try to do so from combo box on sheet thereafter (it reads message error "400"). I'd be grateful if you had any advice!! Thanks in advance.

W

Hello Woopy,

In order to help you, I need to see the workbook. If the workbook contains sensitive or confidential material, please redact it before posting the workbook.

If you are unable to do so, you can contact me by private message to email the workbook to me. All information and code that is not of a sensitive or confidentail nature will be posted for the benefit of the forum.

Woopy, Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.