LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 116
Default How2 accept only numbers in userform textbox

Hello:

I have a useform which requires a user to input data into some textboxes.
The user then clicks a button and some math is done on the data input by the
user.

The problem is that right now there is nothing to prevent the user from
putting anything (text, symbols or whatever) into the boxes, and this causes
a runtime error when the button is clicked.

I'm looking for some code to put into my userform which will generate an
error message if the user inputs anything other than a number into one of the
textboxes.

Help would be appreciated.

Thanks,
MARTY
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 combobox in userform to accept dates Brad Excel Worksheet Functions 3 November 2nd 05 01:11 AM
Max numbers of characters in userform textbox and cell N E Body Excel Programming 4 June 27th 05 06:25 PM
Forcing a Text Box to accept only Numbers Mihalis Excel Programming 2 December 20th 04 03:30 PM
how2 paste into a userform text box? jimredfield[_5_] Excel Programming 2 October 18th 03 12:19 AM
UserForm TextBox to ActiveSheet TextBox over 256 characters Dan E[_2_] Excel Programming 1 July 28th 03 07:36 PM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"