Vba Useform: labelling depending on multiple variables

Hello,

I have the following issue:

I have a table of data, and would like my userform to select parts on this depending on different variables.

When I run the macro "Show_UserFormCalculatePrice" or click the button "Calculate Price", the userform is activated which has 2 comboboxes, Date and Service.

When a certain date a service are selected I would like the the dish name to show in the labels of the userform.

My main issue is that there will be multiple dishes that will correspond to the data, and I would like them to be vertically listed in the labels depending on their number (Column A).

Essentially I would like to run some sort of If function:

If the date and the service correspond to the criteria then they are shown in the labels.

I am sorry that this is such a convoluted explanation.

Any help would be greatly appreictaed.

Benedict

VBALabeling.xlsm

Hi Norie,

Thanks for getting back to me.

I would prefer to use labels, because the idea is that I will have 9 labels, and there will be 9 dishes per service: 3 entradas(Starters), 3 principais (Mains) and 3 sobremesas (desserts).

The idea is that once I have built up the database, I will be able to select the date and service, and the 9 dishes will appear.

Benedict

Hi

Just to let you know I finally worked it out.

I created another column (hidden) which contained the formula:

=IF(B3&C3&COUNTIFS($B$3:B3;B3;$C$3:C3;C3)=0;"-";B3&C3&COUNTIFS($B$3:B3;B3;$C$3:C3;C3))

Then i entered the code:

Please Login or Register  to view this content.

After this I entered "FindPratos" into the change event for cmbDateFinal and cmbServiceFinal, and it worked.