Floating Text Box / Image when you scroll

Hi

i have a spreadsheet which has a cell which says notes, about column which has the time in, this column has been in the real working one formatted so just have to type it in so no need to change cell format or type :

anyway the question i have is

Can you make it so like a java script style menu in html it will follow you as you scroll down?

and just for info the top row is frozen so that stays in place so would rather do it with code then freeze or split which i have tried and didn't work or look very pleasing

Your file was corrupted and not sure what your exact aim is here.

If you want to show static info on floating box/window there are couple of ways.

I prefer to use userform to show info and set it as vbModeless. So it will float and won't move with scroll.

You can also use Camera tool to show info from range and reposition it on scroll. You can see Chip Pearson's site for how to detect scrolling in a worksheet window.
http://www.cpearson.com/excel/DetectScroll.htm

sorry try this version

Paste this into the UserForm:

Please Login or Register  to view this content.

Paste this into ThisWorkbook:

Please Login or Register  to view this content.

I save your workbook as .xlsb so as to reduce its size.

cheers many thanks

You are welcome.

See sample attached.

It's just simple userform using Label1 to show text. ActiveWindow is used to show Userform in same screen as Excel.

In Workbook module.

Please Login or Register  to view this content.