PDA

View Full Version : Solved: Floating a textbox over an excel worksheet



ccRider246
01-18-2010, 03:14 PM
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
01-18-2010, 03:25 PM
http://www.bmsltd.co.uk/Excel/Default.htm

Look for this zip file: FloatWnd.zip (http://www.bmsltd.co.uk/DLCount/DLCount.asp?file=FloatWnd.zip)

ccRider246
01-18-2010, 04:05 PM
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.:thumb

Chris