vbBack... not like a backspace

[rci]

Hi all...

I want to create a keyboard in excel, including the backspace key, to make a
string.

Simple enough String=String & TheKey

But for the backspace... I wanted to ue vbBack to remove the final character
in the string... but it doesn't actually seem to work that way, and vbBack
shows up as a non printable character (represented by a square) in my text
box.

What might I be doing wrong here? Maybe there is no easy way...

Thx...

[Andrew Taylor]

Try this:
myString = Left(myString, Len(myString) - 1)

Post by rci
Hi all...
I want to create a keyboard in excel, including the backspace key, to make a
string.
Simple enough String=String & TheKey
But for the backspace... I wanted to ue vbBack to remove the final character
in the string... but it doesn't actually seem to work that way, and vbBack
shows up as a non printable character (represented by a square) in my text
box.
What might I be doing wrong here? Maybe there is no easy way...
Thx...