What class of objects does a text box created from the Control Toolbox
toolbar belong?

The following code:

Sub ToggleTextBoxes()
Dim bxa As TextBox
For Each bxa In ActiveSheet.TextBoxes
If bxa.Visible = True Then
bxa.Visible = False
Else
bxa.Visible = True
End If
Next bxa
End Sub

will toggle visible/invisible all text boxes created from the Drawing
toobar, but not text boxes created from the Control Toolbox toolbar.
???

Thanks,

Fred Holmes


On Thu, 28 Aug 2003 15:07:36 -0400, "Tom Ogilvy"
wrote:

The textbox you use on a userform can be used on a worksheet as well (from
the control toolbox toolbar)

just put it on the worksheet and change the wrap, multiline and scrollbar
properties to reflect the behavior you want. The scrollbar won't appear
until the text exceeds the height of the visible area (given that vertical
scrollbar is enabled). You would need to set these if you used it on a
userform as well.