sendkeys and the "+"

[John]

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

[Tom Ogilvy]

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

perhaps.

--
Regards,
Tom Ogilvy


"John" <John@discussions.microsoft.com> wrote in message
news:296BCEEC-89D8-4402-BAE4-B77E647D0CC9@microsoft.com...
> 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

[John]

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" <John@discussions.microsoft.com> wrote in message
> news:296BCEEC-89D8-4402-BAE4-B77E647D0CC9@microsoft.com...
> > 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
>
>
>

[Steve Yandl]

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" <John@discussions.microsoft.com> wrote in message
news:7393ADD0-150B-4086-AC50-9B4071FB6221@microsoft.com...
> 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" <John@discussions.microsoft.com> wrote in message
>> news:296BCEEC-89D8-4402-BAE4-B77E647D0CC9@microsoft.com...
>> > 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
>>
>>
>>