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

 

Two things.

1 - I don't fully understand something. I also use pop-up Message Boxes to prompt a user or report errors. Wherever you get the information *from* to put INTO the MegBox is where you can get it to use elsewhere. You can also assign a string to a variable and use that variable in the MsgBox Statement, then use it later.

2 - You can also save the information in a (hiddeen) sheet then grab it for later use. I do much of this as well.

Regards, Steve N.

--- In ExcelVBA@yahoogroups.com, "David Smart" <smartware.consulting@...> wrote:
>
> 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@...>
> 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 (3)

Recent Activity:

• New Members 8

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

.

__,_._,___