Create a floating text box or userform that will scroll up and down

[Zimmerman]

Does anybody know of a way that i could create either a floating text box or a floating userform that will always stay at the top of the sheet so when i scroll down it will still be visible. it's just an information box really that is telling the user that they can click on any item in Blue to go that sheet. I have hyperlinks in each sheet that they can click on.

Excel 2003
Windows XP

 

[hiker95]

Zimmerman,

See if this helps you get started in the right direction:

Floating worksheet buttons
By Jaafar Tribak
http://www.mrexcel.com/forum/showthread.php?t=454648

 

[Zimmerman]

Thanks for the help with trying to get me in the right direction but that link wasn't really anything that could help me. Or at least if it was i couldn't find out how. Thanks again, but does anybody else have any suggestions?

 

[RoryA]

Just load a userform modelessly:

userform1.show false

for example. Or freeze panes at the top of the sheet and put the instructions there.