VBA - Help creating a Macro for a button

*File attached for reference

I am trying to write a large macro associated with the button on 'Sheet2'. First i need to identify the country that i select in the drop down as my 'index'. i am having trouble getting that to happen.

Then, after i define the country, i will then need to have the fields populated below with the information in the Data Field. The catch is that the amount of fields needed may vary from all 5, to only 1. I can use a "hide" function if needed, but was wondering if there was a better way.

Data for Drop down:

Please Login or Register  to view this content.

Jukeboxhero,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

---------- Post added at 05:13 PM ---------- Previous post was at 05:12 PM ----------

Any reason why you are doing it with VBA? You can do this with formulae as well.

Cross posted here

Jukeboxhero,

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

No, your thread is still here.

As is the one at Ozgrid. Basically, it's OK to cross post but have the courtesy to let us know with a simple link.

I can't make any sense of what you are asking. Do you want to show say only Belgium in the data sheet, what goes into the first sheet with the combobox?

forgot attachment