I currently have a drop down list located in G2. I want to write VB code to capture the value selected and based on that value run a certain macro. Any help would be appreciated.