Copy formula results and launch application from button

  • Thread starter Thread starter Kapi187
  • Start date Start date
K

Kapi187

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.
 
when you paste, do

activecell.pastespecial xlValues


look in Excel VBA help at the Shell command.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Macro... 8
Copying a formula to a range 2
copy text from textbox to another application 3
Copy value of textbox to clipboard for use in another application 5
Excel VBA 1
Copy value from changing cells without VBA 1
Launching form blocks cell selection 3
copying formula 1

Back
Top