Userform label dependent from combobox

Hello everyone,

I have a userform in which I have two comboboxes (one dependent from the other, depending from which i select first).

Now I which to add a label that changes according to one of the comboboxes selection. I do not want to have it as a combobox since it's just remark, so the user can only see that remark after the selection from the combobox.

I am able to make the label dependent from I what choose in the combobox, but I cannot put the right "values" in the label caption.

Also, the caption should be something like "13 / 14", with 13 being the column where the information to the left of the dash is stored, and 14 the column to the right of the dash.

Here's the whole userform code:

Please Login or Register  to view this content.

Thank you for your help

Hi,
I'm not sure it's clear what is 13 and 14?
If you know how to get those numbers then combine them in Label.Caption like this:

Please Login or Register  to view this content.

Hi,

13 and 14 are just the column numbers where the information is. I have 13 as the variable temprmks in the code, as you might see in one of the comboxes (Me.ComboBoxRemarks.List). That one was just a test, but if I can do it as a label, then I will delete that combobox.

Sorry about the misleading information.

Hi,

Thank you for your reply.

About my question, Just like I have two comboboxes (prices and suppliers), in which the information shown is dependent from the combobox I choose first (if i choose the supplier, then it shows me the correspondent price, vice-versa), I want another "box", but this one should not allow the user to see the different options, only what is presented after selecting the supplier. I believe the best userform control to do that is to use a label.

Making it dependent works, but I cannot fill the caption with the information I desire. For the combobox, I used the .Listindex, but how can I have a range in the label caption?

About your sugestion, the userform only appears in a specific situation, which creates a temporary sheet for the sole purpose of the userform, so for this case I do not see any gain in changing the code to that purpose, but I will keep it in mind for the future.

Thanks you.