VBA Userform with multiple labels

[jsneak]

Hi everyone,

I was wondering if anyone could help me with a project i'm currently working on that uses a userform. I've attached a dummy file and populated the labels with the information (But it needs to be dynamic)

• Is it possible when the userform loads, it counts how many Metrics have been missed and populates a label in the userform (Currently i have a formula that the userform counts if the actual is less than target but ideally i wouldn't want a formula to drive this)

• Picks the first one thats missed target, populates the target(col B) and actual (col C) numbers for the metric (col A)

• Depending on which metric it is pulls through the definition

• The spinnerbox changes up or down missed metrics, changing the target/actual & definition

• When the reason has been placed and the submit button is hit, it populates the comment from the textbox into the other sheet under comments?

I'm sorry if this is long winded, I've literally I've come to a dead end with it

Thanks in advance

[Leith Ross]

Hello jsneak,

Here is the updated UserForm code. It has been added to the attached workbook.

Please Login or Register  to view this content.

[jsneak]

Leith, you Sir are an absolute legend! Thanks so much.

If i'm being really picky, is there any chance that when the Spinner goes up and down that the number changes? Aslo, cheeky little request - when submit is hit, can it go to the next one?

But honestly, thanks for the help i really appreciate it

I've been able to adapt your code so that the spinner number goes up, is this the way you would do it?

Please Login or Register  to view this content.

[Leith Ross]

Hello jsneak,

I had thought about doing that before I posted but I decided to error on the side of caution. I will make those changes.

[Leith Ross]

Hello jsneak,

Here is the updated USerForm code.

Please Login or Register  to view this content.

[jsneak]

Leith, i can't thank you enough for your help regarding this mate.

Legend mate, thanks!

[Leith Ross]

Hello jsneak,

You're welcome. Glad to help out.