Re: [ExcelVBA] [need] pop-up window

 

You can get VBA to copy information directly to the clipboard. This can
easily be the same information as you then display in the message box.

Do a Google search for: excel vba copy to clipboard

There are lots of examples. This one
http://www.cpearson.com/excel/Clipboard.aspx seems typical but might be
clearer than most.

Regards, Dave S

----- Original Message -----
From: "wasayraza90" <wasay.raza.qadri@gmail.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Thursday, March 08, 2012 7:39 PM
Subject: [ExcelVBA] [need] pop-up window

>i have made a spread sheet for the calculation of oil compositioon at each
>separation and have done som more calculations on them.
> i have made a sub that on double click the msgbox opens and the
> composition at that pressure is shown in that msg box.
>
> problem is that the composition at that msg box cant be copied to be used
> further on any other sheet.
>
> is there any way to copy that composition shown in msgbox or any other
> popup window through which i can show the values and then copy them to use
> further
>
>
> thanking you guys in anticipation,
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search
> the ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1424 / Virus Database: 2113/4857 - Release Date: 03/07/12
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 10

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___