View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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