Floating pop up shape across all worksheets to show cell value

[gmalpani]

Hi,

I prepared a tool to generate total solution pricing with multiple products.
Tool has input sheet where user can make product selection and in same Input sheet, there is a "cell AB2" which shows Total Solution Price based on selected products.
So, Total Solution Price (cell AB2 of Input Sheet) = Sum of price of each product in different products.

Now I wish to have a circular shape with value of "cell AB2" and this shape shall be visible at top right corner even if user change to different worksheets.

Idea is if user go to Product 1 in worksheet 2 and make some changes with some SW licenses qty, changes in total solution price shall be reflected and shall be visible to user without every time going to Input Sheet.

 

[Teeroy]

This would be far easier to do using a modeless userform rather than a shape object.

 

[gmalpani]

Hi Teeroy,

I am not an expert in VBA. I can create a shape in userform but not sure what is modeless userform.
Also, for me it is difficult to write a code.
Can you provide me a VBA code I can use or provide reference link where I can find similar code.

 

[Teeroy]

I find it hard to explain userforms and associated code by text only so I've put together a simple example at Example of userform displaying sum.

Please note the file has code in the ThisWorkBook module, a standard module and a userform module and all is required for it to work correctly.

 

[gmalpani]

Hi Teeroy

Have you attached any file ?
Sorry but I cannot see any attachment with your post.
Is it not visible here with post and I have to look somewhere else in the forum.

 

[Teeroy]

The link is on the text "Example of userform displaying sum" in post 4.

 

[gmalpani]

Hi Teeroy,

Sorry, I was offline for sometime so couldn't reply earlier.

Thanks a lot, that solves my query.

 

[RoryA]

FWIW, Excel's built-in Watch window also provides this functionality.