View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
patrick molloy patrick molloy is offline
external usenet poster
 
Posts: 391
Default How do I display text in a (popup) window?

if you design a userform eith the text etc for your
instructions, then you can create a procedure to show it

eg add a userform and call it frmInstructions
in a standard module add this procedure
PUBLIC SUB ShowInstructions()
frmInstructions.Show
END SUB

assign thsi to your button or whatever.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I need to display some usage instructions when the user
clicks on a "how to use" button.

I can map the button to a macro, but how do I make excel
popup a window to display the desired text?

I looked at pivottables and forms but neither look like
the correct approach. Any thoughts?

~Rick
.