software

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
Hi,

You find something useful on this page (it was a bit high-powered for
me):
techrepublic.com.com/5100-3513-5800329.html

The way I allow for toggling is to put a true/false value in the cell
under the macro button (so it is hidden) eg b1 amp; test this value at the
start of the macro... A bit simpler but it works for me.

sub ToggleButton ()
If ActiveSheet.Range(quot;B1quot;) = True Then
'code to hide info... b/c it is already showing
Else
'code to show info... b/c it is not currently showing
End If
'to toggle value in cell
ActiveSheet.Range(quot;B1quot;).Value = Not (ActiveSheet.Range(quot;B1quot;).Value)
End subHth,
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=502848You might consider typing your comments on another sheet, and hyperlinking to
them and back..........

Vaya con Dios
Chuck, CABGx3
quot;Robert Brydgesquot; wrote:

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