Justincut
asked on
Selecting an option within a Combo Box with VB in Excel
Hi, I just recorded a Macro in Excel where one clicks on a certain business called "Mortgage Business" within a Combo box in Excel and then copies and pastes the data to another spreadsheet.however, it does not work. Can anyone help?
ASKER
Ok, here's the file. The combo box is in the top left hand corner. I want to choose "MORTGAGE PRODUCTS -EMEA" in the combo box, this will change the data and then Copy and Paste Cells (i13:y200).
GM-EMEA-Bal-Sheet-January--15-AVG--2-.xl
GM-EMEA-Bal-Sheet-January--15-AVG--2-.xl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
Also here is the sample code for your reference which you can use to copy data...
I have assumed the value which you looking for is in A Column in Worksheet-1 starting from row-2 and you want to copy
Open in new window
Saurabh...