LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robert Brydges
 
Posts: n/a
Default Popup TextBox/Comment

Hi - I want to display a popup TextBox or Comment which provides about
40 lines of info to worksheet users and requires no input from them. A
Comment would be fine except it won't stay where it is put - always
reverts to it's default position on reopening. Data Validation would
also be fine except I can't resize the box to take all the info I need
to have in there. I can create a TextBox which displays the info, but
I am struggling with an appropriate means of toggling it on and off. I
can create a button-linked macro which displays it - do I need to have
a second button/macro to delete it/resize it down to 1 pixel? I am on
a Mac so no ActiveX controls. Any other suggestions?

Many thanks,
Robert

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a warning popup to a Macro Button Teresa Excel Worksheet Functions 4 January 16th 06 09:27 PM
popup calendar with multiple months shawn Excel Discussion (Misc queries) 0 December 28th 05 02:55 AM
Creating Custom Dialog Boxex (Popup) Brad Sumner Excel Discussion (Misc queries) 9 June 17th 05 02:14 PM
"Why did we get here????" popup jtwspoon Excel Discussion (Misc queries) 3 February 4th 05 04:57 AM
Non-functional Popup Menu Boxes Jim_M Charts and Charting in Excel 0 January 20th 05 04:27 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"