Userform to display the value of another sheet

[saravnepali]

Hi All,

I want to have a userform display value of range A1 from the active sheet which is in another workbook.

And, the name of the workbook might change (but it will always be the Range A1 of the active sheet that the value has to be displayed) So, essentially it has to display the value of range("A1") from the whichever sheet is active.

Is there a way around for this.

Thanks in advance for your help.

[Bernie Deitrick]

You could try assigning this to an event or commandbutton on your userform:

Please Login or Register  to view this content.

[Andy Pope]

As Bernie mentions you can add an object to your userform that will capture workbook and sheet activation.

Add this code to your example userform

Please Login or Register  to view this content.

And add this command to you current userform Initialize event.

Please Login or Register  to view this content.

[saravnepali]

Thanks Andypope and Bernie Deitrick

It helps me for what I want.

It also does opens new prospect for me to work with application level events which I wasn't aware previously. I will have to take it slowly and see how it goes and what it has on offer.