Referring the name of the worksheet from the combobox

[Szwadron6]

Hi!

I am working on the file in order to create some data from the selected excel file.

I created a simple program using the User Form function.
I put the command button that allows me to select a file from my machine.

Then I want to paste data from the selected file into the worksheet entitled "Raw data " & whatever value I put into combobox named cboMarka.

Another words:

when I put into:
Kraj value Polska
Marka value KIA

and after I click into 'Wybierz Plik' I want to paste data from selected file into worksheet Raw Data KIA.

But then error that constant expression required appears

Could you please let me know should I make it done?

Many thanks in advance.

P.S. The error indicated in the bold below and file attached.

Please Login or Register  to view this content.

[mike7952]

Try this

Please Login or Register  to view this content.

[Szwadron6]

All clear. Thanks.

[mike7952]

All clear. Thanks.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.