I have a msgbox with an okay and cancel button and a box for user to input a
value (number). If the user types a number and selects OK or hits the return
key, then the macro executes fine. HOWEVER if the user inputs a number and
hits the enter key on the numeric keypad the macro falls in a heap.

Any ideas why, or does anyone know how I can restrict the user to only using
certain keys???

You should post the relevant code so we can attempt to duplicate the error.

"JLR-Mart" wrote:

I have a msgbox with an okay and cancel button and a box for user to input a
value (number). If the user types a number and selects OK or hits the return
key, then the macro executes fine. HOWEVER if the user inputs a number and
hits the enter key on the numeric keypad the macro falls in a heap.

Any ideas why, or does anyone know how I can restrict the user to only using
certain keys???

Try limiting what the user can enter: Type:=1 means a number:

Sub TryNow()
Dim myT As Double
myT = Application.InputBox("Enter a number...", Type:=1)
MsgBox myT
End Sub

HTH,
Bernie
MS Excel MVP


"JLR-Mart" wrote in message
...
I have a msgbox with an okay and cancel button and a box for user to input a
value (number). If the user types a number and selects OK or hits the return
key, then the macro executes fine. HOWEVER if the user inputs a number and
hits the enter key on the numeric keypad the macro falls in a heap.

Any ideas why, or does anyone know how I can restrict the user to only using
certain keys???

The code is below, although the issue isn't with the user input it's about
different behaviour depending on whether the user submits his answer using
the okay button, the return key or enter key!

On Error Resume Next
RCHOSEN = Application.InputBox("Please enter the row number of the new
part's parent and then choose OK", title:="Please identify the parent of the
new part", Type:=1)
On Error GoTo 0

"Bernie Deitrick" wrote:

Try limiting what the user can enter: Type:=1 means a number:

Sub TryNow()
Dim myT As Double
myT = Application.InputBox("Enter a number...", Type:=1)
MsgBox myT
End Sub

HTH,
Bernie
MS Excel MVP


"JLR-Mart" wrote in message
...
I have a msgbox with an okay and cancel button and a box for user to input a
value (number). If the user types a number and selects OK or hits the return
key, then the macro executes fine. HOWEVER if the user inputs a number and
hits the enter key on the numeric keypad the macro falls in a heap.

Any ideas why, or does anyone know how I can restrict the user to only using
certain keys???

The code worked ok for me.

What does "falls in a heap" mean?

How is RCHOSEN declared?

What is the user typing when it falls in a heap.

What line fails? (The application.inputbox line???)

Any chance you (or the users) have a programmable keyboard and something else is
represented by that enter key on the number keypad?

Are there any macros that could have stolen the function of that key?

Does this happen on everyone's pc -- or just a few? Is every user who has
trouble using the same type keyboard?

I don't have a guess, but with more info, maybe someone will.



JLR-Mart wrote:

The code is below, although the issue isn't with the user input it's about
different behaviour depending on whether the user submits his answer using
the okay button, the return key or enter key!

On Error Resume Next
RCHOSEN = Application.InputBox("Please enter the row number of the new
part's parent and then choose OK", title:="Please identify the parent of the
new part", Type:=1)
On Error GoTo 0

"Bernie Deitrick" wrote:

Try limiting what the user can enter: Type:=1 means a number:

Sub TryNow()
Dim myT As Double
myT = Application.InputBox("Enter a number...", Type:=1)
MsgBox myT
End Sub

HTH,
Bernie
MS Excel MVP


"JLR-Mart" wrote in message
...
I have a msgbox with an okay and cancel button and a box for user to input a
value (number). If the user types a number and selects OK or hits the return
key, then the macro executes fine. HOWEVER if the user inputs a number and
hits the enter key on the numeric keypad the macro falls in a heap.

Any ideas why, or does anyone know how I can restrict the user to only using
certain keys???




--

Dave Peterson

I agree with Dave, the code behaves as it should including the use of the
Numeric Keypad Enter key. The code is not the problem and on a normal
keyboard there should be no problem using either of the enter keys.

"JLR-Mart" wrote:

The code is below, although the issue isn't with the user input it's about
different behaviour depending on whether the user submits his answer using
the okay button, the return key or enter key!

On Error Resume Next
RCHOSEN = Application.InputBox("Please enter the row number of the new
part's parent and then choose OK", title:="Please identify the parent of the
new part", Type:=1)
On Error GoTo 0

"Bernie Deitrick" wrote:

Try limiting what the user can enter: Type:=1 means a number:

Sub TryNow()
Dim myT As Double
myT = Application.InputBox("Enter a number...", Type:=1)
MsgBox myT
End Sub

HTH,
Bernie
MS Excel MVP


"JLR-Mart" wrote in message
...
I have a msgbox with an okay and cancel button and a box for user to input a
value (number). If the user types a number and selects OK or hits the return
key, then the macro executes fine. HOWEVER if the user inputs a number and
hits the enter key on the numeric keypad the macro falls in a heap.

Any ideas why, or does anyone know how I can restrict the user to only using
certain keys???