userform opening on sheet2 but not showing combobox data values

[KK1234]

Hi,
I have created dependent comboboxes in userform.
The combobox data is on sheet1
Data entry is on sheet2
I have created another command button on sheet2 to open userform.
It opens, but does not show comboboxes values

Basically:
I want sheet1 hidden ( which I have managed)
Sheet2 for data entry ( which I have managed)
And userform opens correctly on sheet2 from command button provided. ( Unable to achieve)

Any help please

Kind regards

[HaHoBe]

Hi, KK1234,

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Or at least give us a glimpse at your code.

Ciao,
Holger

[KK1234]

Hi HaHoBe,

Thanks for your prompt reply.
I have attached the sample file as desired by you. Thanks for that again.
I have explained everything in sheet1 and sheet2.

Password for sheet1 is written on sheet1
Hope you can help me.
Many thanks
Kind regards

[HaHoBe]

Hi, KK1234,

I canīt find a need for unprotecting Sheet1 for the reading in Data. You mised to assign the cells to read in to relate to Sheet1, if Cells isnīt referenced with a sheet name it will always take the cells from the active sheet

Behind the UserForm:

Please Login or Register  to view this content.

Ciao,
Hoilger

[KK1234]

Thanks HaHoBe.
I now understand it.
Thanks for explanation.
I indeed was making a mistake.
Great help from you again. A perfect solution again.
You also have helped me before many times.
Thanks