here's a code I have for one of my textboxes
![]()
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) If IsNumeric(TextBox1.Value) Then Label1.Caption _ = Application.Text(Round(TextBox1.Value / 0.03125, 0) * 0.03125, "# ??/??") Else MsgBox "not a number in textbox1" End If End Sub
Bookmarks