Assigning VBA.SendKeys ("^v") to a variable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce Maston - 22 May 2007 14:38 GMT

After you use VBA.SendKeys ("^c") to capture data in a textbox, is there a
way to assign this information to a variable?

A simple line of code strVariable = VBA.SendKeys ("^v") gets a compile error
"expected function or variable"

Thank you.

Reply to this Message

Mr. B - 22 May 2007 16:27 GMT

On May 22, 8:38 am, Bruce Maston
<homeb...@NOSPAMmalpracticedepositions.com> wrote:

> After you use VBA.SendKeys ("^c") to capture data in a textbox, is there a
> way to assign this information to a variable?
[quoted text clipped - 3 lines]
>
> Thank you.

Bruce,

Take a look at using the Clipboard through code as opposed to using
the sendkeys function. Take a look at:

http://www.mvps.org/access/api/api0049.htm

While the sendkeys my seem like a good approach, actually it can have
problems. The best bet is the clipboard.

If you just need to hold on to the value of a textbox, you could just
use a variable as in:

dim strMyVal as String
strMyVal = me.NameOfTexbox

Hope this helps.

Mr. B

Reply to this Message