Is there a VBA to launch a message box, triggered by a specific drop - Microsoft Community

hi everyone,

i have rather complex request here , i’m not sure if possible do… 

i have created mock up picture (below), which may demonstrate request clearer can through text.

i vba code allow me select "archive" in dropdown list (see example 2 in picture) , automatically prompt message box appear 2 options – “okay” , “cancel” (see example 3 in picture).

if “okay” selected, columns d, e, f, g , h automatically hidden (see example 4 in picture).

if “cancel” selected, dropdown list automatically select “live” , no columns hidden (see example 1 in picture).

many thanks,

darren.

after that, should have worked if enabled macros. 

(also had no other code in worksheet module.  default "change" event deleted , change event added or copied code minus duplicate code , pasted in original change event.   (in every case, selectionchange event should have been deleted).  

also, noticed in picture, show dropdown displaying "archived"  code tests "archive" stated in explanation in picture.   so if cell has value "archived", can change 

if lcase(target.value) = "archive" then

to 

if lcase(target.value) = "archived" then

i convert cell value lowercase comparision string constant value comparison case insensitive. 

-- 

regards,

tom ogilvy

Office / Excel / Windows other / Office 2010