Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel 2003 TextBox content Type

Comment:

How can I set the type of the Content of a TextBox in Excel 2003. For Example, textBox only takes Integers and not Strings. Thank You in advance

Name: rhawk7938
Date: May 8, 2006 at 13:06:33 Pacific

Reply:

Something like this should work. Double click your textbox while in design mode and enter this code (change the box name if necessary): Private Sub TextBox1_Change() If Not IsNumeric(TextBox1.Text) Then MsgBox ("enter only numbers") End If End Sub

0

Excel 2002 Displaying Fra...

Adobe toolbar in Microsof...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Is their any addin or is it possible to use data bars in excel 2003 similar to the ones you can conditionally format in 2007? Thanks ...

Summary: I have created the excel file in excel 2003 and transfered it to excel 1997 in my 2nd computer. However when i tried to save the file in excel 1997, i get the error message that some cells have more t...

Summary: Some time ago, I saw an e-mail requesting how to highlight an active cell in Excel 2003. I hope this will help. one way to highlight current cell is using following macro in Excel 2003. It highlight...