Posted to microsoft.public.excel.programming

grinning_crow[_4_] grinning_crow[_4_] is offline

external usenet poster

Posts: 1

putting validation to TextBox in the userform

I think this is along the right lines...

Private Sub textbox1_KeyPress(ByVal KeyAscii As _

MSForms.ReturnInteger)

If Not IsNumeric(Chr(KeyAscii)) Then
msgbox "Please only use numbers"
KeyAscii = 0
End If

End Sub

Hope it is of some use

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
userform textbox	Phil	Excel Worksheet Functions	5	January 16th 05 06:59 PM
UserForm TextBox to ActiveSheet TextBox over 256 characters	Dan E[_2_]	Excel Programming	1	July 28th 03 07:36 PM
Help with Syntax UserForm TextBox	John Wilson	Excel Programming	1	July 28th 03 04:15 PM
Userform Textbox in Password Validation	golf4	Excel Programming	3	July 28th 03 02:27 PM
Populating Textbox in UserForm	Derek[_2_]	Excel Programming	3	July 10th 03 10:41 PM

All times are GMT +1. The time now is 07:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us