ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I keep a "Text Box" visible on screen when scrolling? (https://www.excelbanter.com/excel-discussion-misc-queries/164792-how-do-i-keep-text-box-visible-screen-when-scrolling.html)

pziakin

How do I keep a "Text Box" visible on screen when scrolling?
 
Need to keep an instructional "Text Box" visible on screen of excel based
form as user scrolls through form.

Texas Aggie

How do I keep a "Text Box" visible on screen when scrolling?
 
Use the "Freeze Panes" option. Place the text box in Row 1 and the select row
one

Windows Freeze Panes

That will lock that row and then the user will be able to scroll all rows
underneith Row 1. Allowing the user to view your Instructions even if they
scroll

--
If you found this reply helpful, please indicate that your question has been
answered tell let others know where they might find the answer a simmilar
question.

Silverbird Designs @ www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009


"pziakin" wrote:

Need to keep an instructional "Text Box" visible on screen of excel based
form as user scrolls through form.


pziakin

How do I keep a "Text Box" visible on screen when scrolling?
 
I will try this out!~ Thank you Tex!

"Texas Aggie" wrote:

Use the "Freeze Panes" option. Place the text box in Row 1 and the select row
one

Windows Freeze Panes

That will lock that row and then the user will be able to scroll all rows
underneith Row 1. Allowing the user to view your Instructions even if they
scroll

--
If you found this reply helpful, please indicate that your question has been
answered tell let others know where they might find the answer a simmilar
question.

Silverbird Designs @ www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009


"pziakin" wrote:

Need to keep an instructional "Text Box" visible on screen of excel based
form as user scrolls through form.



All times are GMT +1. The time now is 07:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com