vbBack... not like a backspace
 

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...

vbBack... not like a backspace
 

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


rci wrote:
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...