I have learned to use the Application.InputBox method instead of the
InputBox function when I want to distinguish blank input from
Cancel/ESC.

But Application.InputBox seems to have other features that I wish I
could avoid. It seems to be intended for the input of ranges, even
when you set it up to expect a text string. When I set up the input
field to contain a default text string and I want to modify that
string, if I use any cursor key or the Home key or the End key, instead
of moving the text cursor to where I want it, it inserts a "+" sign and
some "R_C_" text describing the current range of the spreadsheet
cursor.

In other words, I can't re-aim the text cursor to the beginning,
interior, or end of a default string by using the keyboard; I must
always use the mouse and/or the Delete and Erase keys.

Can anyone confirm that there's no easy way around this? (I don't want
to set up a Form or do something really elaborate. It's not that
important.)

Dan Williams
danwPlanet

Check out the last post on this topic by Tom. He taught me how to
detect a cancel without application.inputbox
http://groups.google.com/group/micro...41bfacdb6d1 7
BTW tx Tom :)

Die_Another_Day
Dan Williams wrote:
I have learned to use the Application.InputBox method instead of the
InputBox function when I want to distinguish blank input from
Cancel/ESC.

But Application.InputBox seems to have other features that I wish I
could avoid. It seems to be intended for the input of ranges, even
when you set it up to expect a text string. When I set up the input
field to contain a default text string and I want to modify that
string, if I use any cursor key or the Home key or the End key, instead
of moving the text cursor to where I want it, it inserts a "+" sign and
some "R_C_" text describing the current range of the spreadsheet
cursor.

In other words, I can't re-aim the text cursor to the beginning,
interior, or end of a default string by using the keyboard; I must
always use the mouse and/or the Delete and Erase keys.

Can anyone confirm that there's no easy way around this? (I don't want
to set up a Form or do something really elaborate. It's not that
important.)

Dan Williams
danwPlanet

You're right, that does the trick! Thanks (and thanks, Tom)!
Dan

Die_Another_Day wrote:
Check out the last post on this topic by Tom. He taught me how to
detect a cancel without application.inputbox
http://groups.google.com/group/micro...41bfacdb6d1 7
BTW tx Tom :)

Die_Another_Day
Dan Williams wrote:
I have learned to use the Application.InputBox method instead of the
InputBox function when I want to distinguish blank input from
Cancel/ESC.

But Application.InputBox seems to have other features that I wish I
could avoid. It seems to be intended for the input of ranges, even
when you set it up to expect a text string. When I set up the input
field to contain a default text string and I want to modify that
string, if I use any cursor key or the Home key or the End key, instead
of moving the text cursor to where I want it, it inserts a "+" sign and
some "R_C_" text describing the current range of the spreadsheet
cursor.

In other words, I can't re-aim the text cursor to the beginning,
interior, or end of a default string by using the keyboard; I must
always use the mouse and/or the Delete and Erase keys.

Can anyone confirm that there's no easy way around this? (I don't want
to set up a Form or do something really elaborate. It's not that
important.)

Dan Williams
danwPlanet

Dan,
Are you specifying that you want Text ? e.g.
Dim RetVal As Variant
Const TextOnly As Long = 2
RetVal = Application.InputBox("App InputBox Str Only", , "Dft Text", , , ,
TextOnly)

Arrow keys, Home, End work as expected.

nickHK

"Dan Williams"
egroups.com...
I have learned to use the Application.InputBox method instead of the
InputBox function when I want to distinguish blank input from
Cancel/ESC.

But Application.InputBox seems to have other features that I wish I
could avoid. It seems to be intended for the input of ranges, even
when you set it up to expect a text string. When I set up the input
field to contain a default text string and I want to modify that
string, if I use any cursor key or the Home key or the End key, instead
of moving the text cursor to where I want it, it inserts a "+" sign and
some "R_C_" text describing the current range of the spreadsheet
cursor.

In other words, I can't re-aim the text cursor to the beginning,
interior, or end of a default string by using the keyboard; I must
always use the mouse and/or the Delete and Erase keys.

Can anyone confirm that there's no easy way around this? (I don't want
to set up a Form or do something really elaborate. It's not that
important.)

Dan Williams
danwPlanet

Nick -
Yes, I had tried it with the 2 in there. In fact, when I paste your
code into a test Sub, I still get the symptoms. Odd.
Dan

NickHK wrote:
Dan,
Are you specifying that you want Text ? e.g.
Dim RetVal As Variant
Const TextOnly As Long = 2
RetVal = Application.InputBox("App InputBox Str Only", , "Dft Text", , , ,
TextOnly)

Arrow keys, Home, End work as expected.

nickHK

"Dan Williams"
egroups.com...
I have learned to use the Application.InputBox method instead of the
InputBox function when I want to distinguish blank input from
Cancel/ESC.

But Application.InputBox seems to have other features that I wish I
could avoid. It seems to be intended for the input of ranges, even
when you set it up to expect a text string. When I set up the input
field to contain a default text string and I want to modify that
string, if I use any cursor key or the Home key or the End key, instead
of moving the text cursor to where I want it, it inserts a "+" sign and
some "R_C_" text describing the current range of the spreadsheet
cursor.

In other words, I can't re-aim the text cursor to the beginning,
interior, or end of a default string by using the keyboard; I must
always use the mouse and/or the Delete and Erase keys.

Can anyone confirm that there's no easy way around this? (I don't want
to set up a Form or do something really elaborate. It's not that
important.)

Dan Williams
danwPlanet

Dan,
Well, I don't what to say as I can't reproduce your problem with this code.

NickHK

"Dan Williams"
egroups.com...
Nick -
Yes, I had tried it with the 2 in there. In fact, when I paste your
code into a test Sub, I still get the symptoms. Odd.
Dan

NickHK wrote:
Dan,
Are you specifying that you want Text ? e.g.
Dim RetVal As Variant
Const TextOnly As Long = 2
RetVal = Application.InputBox("App InputBox Str Only", , "Dft Text", , ,
,
TextOnly)

Arrow keys, Home, End work as expected.

nickHK

"Dan Williams"
egroups.com...
I have learned to use the Application.InputBox method instead of the
InputBox function when I want to distinguish blank input from
Cancel/ESC.

But Application.InputBox seems to have other features that I wish I
could avoid. It seems to be intended for the input of ranges, even
when you set it up to expect a text string. When I set up the input
field to contain a default text string and I want to modify that
string, if I use any cursor key or the Home key or the End key, instead
of moving the text cursor to where I want it, it inserts a "+" sign and
some "R_C_" text describing the current range of the spreadsheet
cursor.

In other words, I can't re-aim the text cursor to the beginning,
interior, or end of a default string by using the keyboard; I must
always use the mouse and/or the Delete and Erase keys.

Can anyone confirm that there's no easy way around this? (I don't want
to set up a Form or do something really elaborate. It's not that
important.)

Dan Williams
danwPlanet

Well, the earlier suggestion works, so I'll go with that. Thanks for
trying it out!

In case anyone's inclined to snoop into the new mystery: I'm using
Excel 2000 and Windows 2000.
Dan

NickHK wrote:
Dan,
Well, I don't what to say as I can't reproduce your problem with this code.

NickHK

"Dan Williams"
egroups.com...
Nick -
Yes, I had tried it with the 2 in there. In fact, when I paste your
code into a test Sub, I still get the symptoms. Odd.
Dan

NickHK wrote:
Dan,
Are you specifying that you want Text ? e.g.
Dim RetVal As Variant
Const TextOnly As Long = 2
RetVal = Application.InputBox("App InputBox Str Only", , "Dft Text", , ,
,
TextOnly)

Arrow keys, Home, End work as expected.

nickHK

"Dan Williams"
egroups.com...
I have learned to use the Application.InputBox method instead of the
InputBox function when I want to distinguish blank input from
Cancel/ESC.

But Application.InputBox seems to have other features that I wish I
could avoid. It seems to be intended for the input of ranges, even
when you set it up to expect a text string. When I set up the input
field to contain a default text string and I want to modify that
string, if I use any cursor key or the Home key or the End key, instead
of moving the text cursor to where I want it, it inserts a "+" sign and
some "R_C_" text describing the current range of the spreadsheet
cursor.

In other words, I can't re-aim the text cursor to the beginning,
interior, or end of a default string by using the keyboard; I must
always use the mouse and/or the Delete and Erase keys.

Can anyone confirm that there's no easy way around this? (I don't want
to set up a Form or do something really elaborate. It's not that
important.)

Dan Williams
danwPlanet

Dan Williams wrote:
Well, the earlier suggestion works, so I'll go with that. Thanks for
trying it out!

In case anyone's inclined to snoop into the new mystery: I'm using
Excel 2000 and Windows 2000.
Dan

NickHK wrote:
Dan,
Well, I don't what to say as I can't reproduce your problem with this code.

NickHK

"Dan Williams"
egroups.com...
Nick -
Yes, I had tried it with the 2 in there. In fact, when I paste your
code into a test Sub, I still get the symptoms. Odd.
Dan

NickHK wrote:
Dan,
Are you specifying that you want Text ? e.g.
Dim RetVal As Variant
Const TextOnly As Long = 2
RetVal = Application.InputBox("App InputBox Str Only", , "Dft Text", , ,
,
TextOnly)

Arrow keys, Home, End work as expected.

nickHK

"Dan Williams"
egroups.com...
I have learned to use the Application.InputBox method instead of the
InputBox function when I want to distinguish blank input from
Cancel/ESC.

But Application.InputBox seems to have other features that I wish I
could avoid. It seems to be intended for the input of ranges, even
when you set it up to expect a text string. When I set up the input
field to contain a default text string and I want to modify that
string, if I use any cursor key or the Home key or the End key, instead
of moving the text cursor to where I want it, it inserts a "+" sign and
some "R_C_" text describing the current range of the spreadsheet
cursor.

In other words, I can't re-aim the text cursor to the beginning,
interior, or end of a default string by using the keyboard; I must
always use the mouse and/or the Delete and Erase keys.

Can anyone confirm that there's no easy way around this? (I don't want
to set up a Form or do something really elaborate. It's not that
important.)

Dan Williams
danwPlanet

What is the solution you are using for cursor keys. I have the same problem and I need to be able to use the keys for entering the numbers . Help is Appretiated, Thanks