![]() |
Inputbox
ok im having trouble with my imput box it crashes when i enter text, nothin and when i press the cancel button. i do realise when i click the cancel buttin it returns a null value and vb doesnt like it but why does it crash with letters or typing nothin because i have put if it = "" then.... shouldnt that mean it will accept nothin entered?
heres one of the input boxes maybe u can tell what im doin wrong and how to fix it. Code:
If question1 = 1 And level = 0 And x >= 134 And x < 275 Then |
Re: Inputbox
The code looks clean to me and according to me it works if you write
If Q = "" Did you try debugging? Does it crash at this statement? You can try using vbNull or just NULL, whichever works correctly. ElseIf Q = vbNull Then or ElseIf Q = Null Then Let me know the outcome. - Nimesh |
Re: Inputbox
i got a reply on another forum and that way seems to have worked perfect plus made the code alot shorter but thanks for your reply :)
|
| All times are GMT +5.5. The time now is 16:28. |