Making VBA Form TextBox accept Numbers only (including +, – and .)

by

Further to my comment:

Consider a sample Userform1 with a Textbox1 and a CommandButton1

enter image description here

when you enter anything in the TextBox1 the change event fires – ie. typing one character fires the Change() event and passes the current value so even when you type in the negative sign your current logic fails.

What you need is to use another event like _AfterUpdate() or _Exit() with an amphasis on the second one because your can cancel the event 🙂

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    If Not IsNumeric(TextBox1.Value) Then
        MsgBox "only numbers allowed"
        Cancel = True
    End If
End Sub

You can find events here:

enter image description here

More Related Contents:

  1. Loop through files in a folder using VBA?
  2. How to error handle 1004 Error with WorksheetFunction.VLookup?
  3. How can Excel VBA open file using default application
  4. Create a new sheet for each unique agent and move all data to each sheet
  5. How to compare two entire rows in a sheet
  6. Run same excel macro on multiple excel files
  7. how to detect whether VBA excel found something?
  8. VBA : save a file with UTF-8 without BOM
  9. Excel tab sheet names vs. Visual Basic sheet names
  10. Saving a Excel File into .txt format without quotes
  11. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  12. Determine if cell contains data validation
  13. VBA – Range to jpg picture
  14. Fastest way to delete rows which cannot be grabbed with SpecialCells
  15. Combine multiple Excel workbooks into a single workbook
  16. Excel Macro, inserting internationally valid formula during run-time
  17. Sheet protection: UserInterFaceOnly gone
  18. VBScript – How to make program wait until process has finished?
  19. How to break long string to multiple lines
  20. How to copy a chart from Excel to PowerPoint?
  21. vba paste not working
  22. mac excel vba loop : from list & then export as pdf
  23. Can Advanced Filter criteria be in the VBA rather than a range?
  24. In Excel VBA, what is the way to check if the web page is fully loaded?
  25. Excel Useform: How to hide application but have icon in the taskbar
  26. Reading Web Pages using Excel VBA
  27. Excel VBA: auto click and open file from website
  28. How do I get a list of unique values from a range in Excel VBA?
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment