Display a textbox embedded in the Excel sheet

[Tom Shi]

Hi, can anyone tell me is it possible to display a textbox embedded in a worksheet? The textbox is not for user-input, and just display default text. Thanks a lot.

Tom

[Tom Ogilvy]

Just look at the sheet. Scroll it into view if necessary.

or perhaps if you meant in code:


msgbox Activesheet.Textboxes(1).Text

for a textbox from the drawing toolbar

for a control toolbox toolbar textbox

msgbox Activesheet.TextBox1.Text


--
Regards,
Tom Ogilvy


"Tom Shi" <[email protected]> wrote in message
news:[email protected]...
Hi, can anyone tell me is it possible to display a textbox embedded in a
worksheet? The textbox is not for user-input, and just display default
text. Thanks a lot.

Tom



----------------------------------------------------------------------------
----


Hi, can anyone tell me is it possible to display a textbox embedded in a
worksheet? The textbox is not for user-input, and just display default
text. Thanks a lot.

Tom