Floating Info Box

[Shazz]

Hi All,

Can anyone help at all, on the attached Excel Spreadsheet I would like a floating box with Nightshirt info in it so when you scroll down that info is visible at all times.

I have no idea how to go about this.

Can anyone help at all?

Shazz
xx

 

[Hui]

Shazz

I've added a modeless userform which loads when you activate the worksheet
It floats as requested even when you scroll

You can Move, Resize or Close it
To reactivate it change worksheets then change back


Enjoy

 

[Chihiro]

@Hui
Neat way to do it.

Here's alternate method.
Used Camera tool to show info (info moved to another sheet).
Then used code found in link.
http://www.mrexcel.com/forum/excel-...-picture-stationary-scroll-moves-out-way.html

However, this method requires selection change within worksheet (click or arrow key). It will not move picture until cell selection changes.

I like Hui's method better.

 

[Shazz]

Hui,

If I were to message you my actual spreadsheet, would you be able to recreate the box for me as I am unsure of how to get this into my spreadsheet.

Shazz

 

[Shazz]

I have re-created the box but have no idea how to have it show on the spreadsheet.

Can you advise Hui?

Shazz
x