Macro to change drop down box selection

Hello,

I'd like to write a macro which changes the selection in a drop down menu (created using Data Validation\Settings\Allow\List) but I don't know how to do this.

Normally when I'm stuck I tend to start recording a macro, do the function manually, and then stop and go in and check the code, however when you record a macro and then change the selection in a drop down box, it doesn't pick up that you have done anything.

The reason I want to do this is that each selection in the drop down box causes data to change and this is linked into a graph. I want the macro to change the selection, then copy and paste the graph to another workbook, and then go to the next selection and so on.

Any thoughts/help much appreciated.

Thanks for the reply

Sorry, I gave the wrong information

The problem I have is its a drop down box created by right click and then "control" tab and then selecting the range, not the validation command I suggested in the initial post, sorry, so

Range("cell").Value =

doesn't work as its a box not a cell

Thanks for the help but I've finally cracked it

Please Login or Register  to view this content.