Hi everscern,
I assume you're really referring to textboxes, not edit boxes. Edit boxes are only used on Dialog sheets, which became obsolete with Excel 97. To limit a textbox to numeric entry, simply place code like the following into the code module of the sheet or userform on which the textbox resides:
Private Sub TextBox1_Change()
If TextBox1.Text = "" Then Exit Sub
If IsNumeric(TextBox1) Then Exit Sub
TextBox1 = ""
End Sub
This will simply clear the textbox if non-numeric text are entered. This will work for everything except exponential notation (e.g., 1.602E-23) because the 1.602E will not be recognized as numeric by the IsNumeric function. But such numbers can be entered if one is willing to enter 1.60223 first, then move the cursor back and enter the E-.
Similiar code will also work for edit boxes (in case you really did mean edit boxes). Let me know if this is the case and I'll provide it.