Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: xyxex
  • Content: Threads
  • Order by date
  1. xyxex

    Use a Textbox name in code as a variable

    xyxex (TechnicalUser) 19 Mar 09 7:51 I have a piece of code that checks a value entered in a textbox is numeric. Private Sub txtTargetInc_Change() If HasNumber(txtTargetInc) = True Or txtTargetInc = "" Then GoTo OUT numerror OUT: End Sub I want to re-use this code for all numeric fields by...
  2. xyxex

    Re-using code where only variable is the control

    I have a piece of code that checks a value entered in a textbox is numeric. Private Sub txtTargetInc_Change() If HasNumber(txtTargetInc) = True Or txtTargetInc = "" Then GoTo OUT numerror OUT: End Sub I want to re-use this code for all numeric fields by bringing the control name into the...
  3. xyxex

    Named ranges in VBA

    I am trying to write a loop that will populate a group of named worksheet cells. my code is Private Sub Rate_Change() 'update rates when one is changed Dim i, Text As String, newtext As String, Text2 As String, NewText2 As String, h Text = "txtrate" Text2 = "data!rate"...
  4. xyxex

    Viarables as object names

    I have a number of textboxes on a user for that I need to perform the same action on. I am trying to write a loop that will take a common part of the name and add a numbe to the end. This new text then becomes the textbox name Private Sub Loop1() Dim Coretext, Newtext Coretext = "Textbox" For i...

Part and Inventory Search

Back
Top