Copy and Paste to Worksheet using Combobox (ActiveX)

Hello

I managed to put the names of my other worksheets into some comboboxes in the main worksheet by using this code:

Please Login or Register  to view this content.

What I am trying to do now is this:

If a user chooses one of the name, Cells B3:E5 of that worksheet will automatically be copied to Cells C3:F5 of the main worksheet.

I looked at the following thread and came up with the following wrong code:

http://www.excelforum.com/excel-prog...box-value.html

Please Login or Register  to view this content.

I am not too sure what to do. Any help will be greatly appreciated!

Your code to populate the combobox looks a bit over complicated.

Assuming you have the worksheet names loaded something like

Please Login or Register  to view this content.

I was just leaving from work & copied your code without noticing your ranges are wrong, replace cells with range

Please Login or Register  to view this content.

Can you attach your workbook?

Thanks Roy so much for your help!

I can't find the code that I gave you.

Your existing code could do with some major tidying up e.g. you don't need to select or activate the ranges you could populate the comboboxes with a loop eliminating the code for individual comboboxes

I found the reason! It should be

Please Login or Register  to view this content.