Solved: Floating a textbox over an excel worksheet

[ccRider246]

Maybe what I am trying to do can't be done. Is it possible to write code to float a textbox over a worksheet so that the textbox will remain in view as the user scrolls down the sheet. I would like to do this without have to freeze a large number of cells at the top of the sheet and place the textbox in the frozen cells. Any ideas on this?

Thanks in advance,
Chris

Sorry, XL12 Windows 7

[lucas]

http://www.bmsltd.co.uk/Excel/Default.htm

Look for this zip file: FloatWnd.zip

[ccRider246]

Thanks for the quick reply, Steve. For some reason I could not open it on my new computer (still getting use to it) but I took it to my XP test machine I have running 2003 and it opened. That is very neat, thank you.

I see this works by creating a non-modal window using API calls. Very cool. I can use this process. I will just have to play around with adding a form closing button in lieu of the timer feature.

This got me thinking about another way to do it with a non-modal user form attached to a selection change event on the work sheet.

Thanks so much for the help. Very nice bit of code there.

Chris