Posted to microsoft.public.excel.programming

[email protected] marston.gould@alaskaair.com is offline

external usenet poster

Posts: 102

Ensuring UserForm Textbox Entry is numeric

Hi - I've tried several different things that would
be logical in a spreadhsheet to ensure that the
entry into a Textbox is a number such as:

If WorksheetFunction.IsError(Clng(Textbox1.Value)) Then

But it dies on the Type mismatch.
Is there some way to trap the entry that I'm not thinking of?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Format Numeric data in Textbox	stickandrock	Excel Worksheet Functions	1	October 25th 05 01:44 AM
Textbox in userform	Harald Staff	Excel Programming	0	September 8th 04 11:51 AM
Textbox in userform	shaharul[_6_]	Excel Programming	3	April 15th 04 12:54 PM
UserForm TextBox to ActiveSheet TextBox over 256 characters	Dan E[_2_]	Excel Programming	1	July 28th 03 07:36 PM
Use numeric data from a textbox on an userform	Excel[_3_]	Excel Programming	0	July 23rd 03 04:45 PM

All times are GMT +1. The time now is 01:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us