Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have multipage userform that has three input items on one page
When I enter a valid number on the last item, it doesn't do anything until I click somewhere else. When I input a valid number on the other two items, the logic formats the numbers correctly. How do I get the last field to format, without clicking the mouse? Code found below - Sub txbP20_Exit(ByVal Cancel As MSForms.ReturnBoolean) Call FaceLimitCheck(txbP20) End Sub Sub txbP30_Exit(ByVal Cancel As MSForms.ReturnBoolean) Call FaceLimitCheck(txbP30) End Sub Sub txbP65_Exit(ByVal Cancel As MSForms.ReturnBoolean) Call FaceLimitCheck(txbP65) End Sub Sub FaceLimitCheck(Facecheck) If Not (Facecheck = vbNullString) Then If Not (IsNumeric(Facecheck)) Then MsgBox ("Invalid entry please use numbers") Facecheck.Value = "" Facecheck.SetFocus Else If Facecheck < 25000 Then MsgBox ("Minimum face amount is 25,000") Facecheck.Value = "" Else Facecheck.Value = Format(Facecheck, "$ #,##0,000") End If End If End If Call CheckTotalFace End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to ask for a item# and then show all details for that item | Excel Discussion (Misc queries) | |||
To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
I need to pair each item on one list to each item on another list | Excel Worksheet Functions | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |