How do I display text in a (popup) window?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

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
 
Use the Msgbox on Button press

Example:

msgbox "This is the direction"

msgbox Range("d10").Value
 
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
 
Back
Top