sendkeys and the "+"
 

I am trying to send +, -, x, or / ....to an application using the SendKeys
command.

I am using the following command line
SendKeys Format(Range("r6").Value, 1)

where R6 equals the plus, minus, x or / ....everything works fine except
for the plus sign? How can I send a plus sign to my application?

thanks

sendkeys and the "+"
 

Sendkeys left(range("r6").Text,1)

perhaps.

--
Regards,
Tom Ogilvy


"John" wrote in message
...
I am trying to send +, -, x, or / ....to an application using the
SendKeys
command.

I am using the following command line
SendKeys Format(Range("r6").Value, 1)

where R6 equals the plus, minus, x or / ....everything works fine except
for the plus sign? How can I send a plus sign to my application?

thanks

sendkeys and the "+"
 

That doesn't get it.

here is the command again... the other one was just making it more difficult

SendKeys Range("r6").Value

If R6 is a plus sign... how do I tell VBA to send a plus sign?

thanks

"Tom Ogilvy" wrote:

Sendkeys left(range("r6").Text,1)

perhaps.

--
Regards,
Tom Ogilvy


"John" wrote in message
...
I am trying to send +, -, x, or / ....to an application using the
SendKeys
command.

I am using the following command line
SendKeys Format(Range("r6").Value, 1)

where R6 equals the plus, minus, x or / ....everything works fine except
for the plus sign? How can I send a plus sign to my application?

thanks

sendkeys and the "+"
 

John,

When I write scripts, I know that the plus sign is one of the "special"
characters that causes problems and requires that it be surrounded by curly
braces, "{+}". I think I'd run a test with an if statement and include the
curly braces in the case where the value of r6 is a plus sign.

Steve


"John" wrote in message
...
That doesn't get it.

here is the command again... the other one was just making it more
difficult

SendKeys Range("r6").Value

If R6 is a plus sign... how do I tell VBA to send a plus sign?

thanks

"Tom Ogilvy" wrote:

Sendkeys left(range("r6").Text,1)

perhaps.

--
Regards,
Tom Ogilvy


"John" wrote in message
...
I am trying to send +, -, x, or / ....to an application using the
SendKeys
command.

I am using the following command line
SendKeys Format(Range("r6").Value, 1)

where R6 equals the plus, minus, x or / ....everything works fine
except
for the plus sign? How can I send a plus sign to my application?

thanks