Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula results and launch application from button
I hope someone can help me... I'm trying to create a worksheet in
excel where the user inputs a number and a result shows in the following cell. I want to create a button where when they click on it the button copies the result into the clipboard and at the same time launches an external program. I got the button to copy the cell but it's copying the formula from the cell not the results. And i'm not sure where to start with having it launch an application... any help is appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula results and launch application from button
when you paste, do
activecell.pastespecial xlValues look in Excel VBA help at the Shell command. -- Regards, Tom Ogilvy "Kapi187" wrote: I hope someone can help me... I'm trying to create a worksheet in excel where the user inputs a number and a result shows in the following cell. I want to create a button where when they click on it the button copies the result into the clipboard and at the same time launches an external program. I got the button to copy the cell but it's copying the formula from the cell not the results. And i'm not sure where to start with having it launch an application... any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Launch Click Event Using Application.Run | Excel Discussion (Misc queries) | |||
Auto launch application & run macro | Excel Programming | |||
Launch external application | Excel Programming | |||
Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
Launch an external telnet application | Excel Programming |