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
Bookmarks