Case Select not catching right column in Userform's Combobox

Good day,
I have the following code in my Userform:

Please Login or Register  to view this content.

I have different sheet but some information will be repeated in these sheets. When I bring my Userform on Case 6, it doesn't populate the right case Selection. Why is this code not functioning well?

I mean I am closing my "With" therefore should not be looking in my Sheets("Evaluation") on case 6 when I trigger Case 6 in Sheets("Pre-Solicitation").

Hi,

Maybe this :

Please Login or Register  to view this content.

When working with different sheets, make sure that you use .Range(xxx) instead of Range(xxx) to "link" the range to the proper sheet. Otherwise, the range refers to the active sheet.

Maybe an other hint :
Let's say you are in your sheet "Pre-solicitation", cell A1. This is your ActiveCell.
Your Select Case doesn't validate if the ActiveCell is in sheet "Pre-sollicitation" or "Evaluation" or "Report". It only checks the column of the ActiveCell.

You might need to add an other verification such as

Please Login or Register  to view this content.

To verify in which sheet is your ActiveCell.

Am I clear?

Runtime Error '381':
Could not set the List Property. Invalid Property Array Index

In which sheet are your named range?

Ok, then this is not the problem an d you do not need to use .Range("xxxx").
Best practice, I would use Sheets("Control").Range("xxx").

What about my other suggestion ?

What is the code meant to do?

Is it supposed to populate ComboBox1 based on which sheet is active and which cell is selected in that sheet?

If it is then perhaps something like this, untested, code would work.

Please Login or Register  to view this content.

Your With in that code doesn't do anything.

No need for 3 variables for the last row(s).

Again untested.

Please Login or Register  to view this content.