Quick VBA Form query

stevehorton09 · Aug 3rd 2004

Hi everyone,

Is it possible in a vba form to limit what type of character can be inputed in a combo box.

I want it to limited to just numbers

I have looked through the properties but seem to be blind!!

Thanks in advance

steve

**royUK** · Aug 3rd 2004

Code

Option Explicit






     ' Written by royUK
     '   [url]www.excel-it.com[/url]
     
   
     
    Dim TbCheck
   ' Assign value.
If TbCheck = IsNumeric(TextBox1) Then
 MsgBox "Is not A Number "
 
 Else
  MsgBox "Is A number"
  
  End If

Display More

Put this in the Textbox_Change adapt to suit.

I am sure Dave has an article on validating TextBox entries on the main site

stevehorton09 · Aug 3rd 2004

cheers ! thanks for your help

Quick VBA Form query

Participate now!

Share

Users Viewing This Thread