Pop Up Box

  • how do you reference cells in a popup box? i want a box to come up at the end of a macro and have cell values referenced in it. thanks for the help.

  • Re: Pop Up Box


    This is probably just a msgbox function.


    At the end of your macro have something like


    Code
    MsgBox(Sheets("YourSheet").Range("A1"))


    to display the contents of cell A1 on a sheet called YourSheet in a pop up box.

  • Re: Pop Up Box


    i cant seem to get your suggestion to return more then one cell. i would like to return h2:n12. and for total kicks be able to print this. thanks

  • Re: Pop Up Box


    Is this what you mean


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!