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
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