Hi everyone,

I'm trying to populate a dropdown box in excel using VBA.

I have a dropdown already in excel, created using data validation, but its empty. What I want to do is, based on the value of another cell, populate this dropdown box with values using VBA. I realise that this can be done in excel, but, just for interest sake, and also as it would require a lot of manual input otherwise, I would like to do it using VBA.

Any help would be great.
Thanks!