Change userform label1 text depending on which sheet the userform is open from?

[danbates]

Hi,

What I would like is to be able to do is change the label text depending on which sheet the userform is triggered from.

If the userform is triggered from Sheet1 then I would like ONE to show as the label1 text.
If the userform is triggered from Sheet2 then I would like TWO to show as the label1 text and so on.

These are just an example, if this is possible then I can alter the text to suit.

Any help would be appreciated.

Thanks

Dan

 

[danbates]

Absolutely perfect.

Thank you so much Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.