+ Reply to Thread
Results 1 to 1 of 1

Display Scenarios using a Combo Box

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    VIC, Australia
    MS-Off Ver
    2007
    Posts
    6

    Red face Display Scenarios using a Combo Box

    Hi,

    I've had a similar issue as http://www.excelforum.com/excel-prog...ml#post3842924

    I'm trying to replicate the VBA code for displaying scenarios using a drop-down (only I am using a combo box) list that I found on this website:

    http://www.tvmcalcs.com/blog/comment...rop_down_list/

    I've not been able to get it to work on my worksheet properly. When I run the code in VBA it updates on sheet, but it doesn't update when I try to do so from the combo box on sheet thereafter (it flicks back to VBA and reads message error "400").

    Just wondering if anyone could assist me to correctly write the VBA code for a combo box (form control). I've attached my workbook.

    Thanks!!

    W

    Capture.PNG
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Display Scenarios Using a drop-down list
    By judasdac in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-23-2014, 12:31 AM
  2. Replies: 8
    Last Post: 12-26-2013, 02:23 PM
  3. VBA to display scenarios based on Combo Box Selection
    By judasdac in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-07-2012, 05:37 AM
  4. Combo box to display 2 columns?
    By Rams in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-10-2011, 08:23 AM
  5. Combo box display to display blank - not the last value - how?
    By barryleajo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2010, 06:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1