Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a several forms that use some code form Dave Peterson web site, to
limit the input on textboxes to "Numbers", is there a way to have a "function" or like, to help reduce code size by eliminating some of the repeated code for each textbox (about 50). code is below I think I am looking for a way to reference the "live" textbox. Private Sub TextBox11_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Select Case KeyAscii Case Asc("0") To Asc("9") Case Asc("-") If InStr(1, Me.TextBox11.Text, "-") 0 Or Me.TextBox11.SelStart 0 Then KeyAscii = 0 End If Case Asc(".") If InStr(1, Me.TextBox11.Text, ".") 0 Then KeyAscii = 0 End If Case Else KeyAscii = 0 End Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I reduce my document to one page? | Excel Discussion (Misc queries) | |||
Reduce subtotals all at once? | Excel Discussion (Misc queries) | |||
How to reduce table? | New Users to Excel | |||
Reduce # of pages | Excel Discussion (Misc queries) | |||
Reduce size file | Excel Discussion (Misc queries) |