Is there a shortcut to copy data from Formula Bar?

[mcmilja]

Hello,

I have created a database update macro using macroexpress which copies data
from excel and pastes it into a database. I have the macro set up to click
on a specific cell in the worksheet and it types ctrl+c to copy the data.
The problem is that 50% of the time when I copy from the cell, whether I'm
using my macro or copying manually, it does not paste into the field in the
database. I have found that if I click on the cell and then copy the data
from the Formula Bar that it will paste into the database field 99% of the
time. So my question is, is there a shortcut to copy data from the Formula
Bar that I can use in my macro?

Thanks,
Jaret

 

[Peo Sjoblom]

F2, then shift + home, ctrl + c then esc


--


Regards,


Peo Sjoblom

 

[Gord Dibben]

Have you thought about getting rid of the third-party macroexpress and using
Excel's built-in VBA macro capabilities?

See Ron de Bruin's site for copy/paste/merge example code for moiving data to a
database.

http://www.rondebruin.nl/tips.htm

There is no shortcut that I know of for copying directly from the Formula Bar.


Gord Dibben MS Excel MVP

 

[mcmilja]

Thank you very much!!

F2, then shift + home, ctrl + c then esc


--


Regards,


Peo Sjoblom

 

[mcmilja]

Hello Gord,

I have to use macroexpress because I need the use of mouse and keyboard
stroke commands to have the macro navigate to where the fields are located
within the software client to update them.

Thanks,
Jaret