FAO LSTAN: I need more help with my VB Text Box!

[Knoxville]

Sorry for the re-post, but I didn't know whetehr you'd seen it and I really need your help!

The key press technique kind of works. Only thing is, it doesn't void the text box for you so it is possible to carry on leaving the string in there.

I've tried some thing like:

Case Else
MsgBox "Not a Number." : Textbox1 = ""

But it doesn't like it.

I tried implementing your first solution (as I thought the occurrance of 'd' or 'e' was too remote, especially for the number of times this project will be used).

But, I've got a group of three text boxes on one page of a multipage. When you exit the final box, and you've left it null or put a string in or anything it doesn't give a message at all!

Any more help you can give would be greatly apreaciated!

Thanx

"Thicky" Knoxville

 

[SkipVought]

Hi,
Wasn't in on the original, but mebe I can help.

In the event that you will use to evaluate the contents of your textboxes (probably a CommandButton Click Event)

' retrieve value from the textbox
    MyText = TextBox1.Value
' now initialize the textbox
   TextBox1.Value = ""

of course, TextBox1 (or whatever one) may need an object like a userform or a worksheet

Hope this helps Skip,
metzgsk@voughtaircraft.com