Hello everyone.

I wonder if it's possible to set a input mask for a textbox.

I've got on my userform a textbox and a commandbutton. pressing th
button will insert the textbox.value into the cell.

I've got fixxed that when cell is empty then there will pop-up a msgbo
with "Nothing typed"

What I want is that when I insert spaces and or letters
and press the button, a msgbox will appear with:Only numbers ar
allowed or something.

Is that possible???


GreetZ Stift,

(I'm a C++-experienced programmer but not very experienced VB(A
programmer

--
Message posted from http://www.ExcelForum.com

Hi

See yesterday's thread "Textbox Validation" for a solution that discards
anything but numeric entries.

HTH. Best wishes Harald


"Stift " skrev i melding
...
Hello everyone.

I wonder if it's possible to set a input mask for a textbox.

I've got on my userform a textbox and a commandbutton. pressing the
button will insert the textbox.value into the cell.

I've got fixxed that when cell is empty then there will pop-up a msgbox
with "Nothing typed"

What I want is that when I insert spaces and or letters
and press the button, a msgbox will appear with:Only numbers are
allowed or something.

Is that possible???


GreetZ Stift,

(I'm a C++-experienced programmer but not very experienced VB(A)
programmer)


---
Message posted from http://www.ExcelForum.com/

Thanks Harald,I saw the topic yesterday but I didn't understand th
sourcecode. I simply copy-pasted it in my source and it works great

--
Message posted from http://www.ExcelForum.com