inputbox value not avaialble

[Shadow123]

Hi, appoligise for the double post... :/ can't find the other one...

Can anyone tell me why this doesn't work... its a brand new workbook, nothing else at all in it. The debug print returns the value of the input box just fine, but the message box is always blank

Public inputvalue As Long
Sub testing()
inputvalue = InputBox("Please enter value")
Debug.Print inputvalue
Call messageformat
End Sub

 Sub messageformat()
MsgBox (inputvaluve)
End Sub
</PRE>

 

[VoG]

Typo

MsgBox (inputvaluve)

 

[Shadow123]

sigh.... 24 hrs i have been stuck... that is just stupid. Sometimes i want to throw it out of the window lol.

Thanks very much, turns out that was the problem in the other book as well.

 

[VoG]

In the VBE, Tools > Options, tick Require variable declaration. That will pick up that sort of issue.

 

[Shadow123]

i turned that off about a week ago, got fed up with the message when i was testing stuff... now I remember why i turned it on lol.

Done.