View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Pank Pank is offline
external usenet poster
 
Posts: 50
Default How do I format a MSGBOX to show text and variables in a macro?

I have a macro that receives a variable that is input by a user (&rsp1)

I want a MsgBox to display €œDo you want to print off the data for €œand the
variable &rsp1.

The MsgBox lookes like:-

MsgBox "Do you want to print off the data for &rsp1 - 1?", vbYesNo, "Do you
want to Print off€

Additionally, if I know the location of a particular file, how do I
incorporate an open to it?

Any assistance offered will be appreciated.