Display a textbox embedded in the Excel sheet
 

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

Display a textbox embedded in the Excel sheet
 

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" wrote in message
...
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