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: *

  1. OscarAlberto

    Inputbox: Exit nested For Each-Next without leaving the execution

    How do I go about providing the user with a MsgBox containing information about an error made while making data entries via an InputBox, and then returning to the execution point where it was left when the error appeared? If I provide a UserForm to obtain input it is relatively easy to trap an...
  2. OscarAlberto

    UserForm to UserForm content of variable

    I am using a Standard Module, Public defined variable, named SourceID, to pass its contents from a UserForm to another UserForm, but it is not working. The code in the first UserForm is the following: Private Sub OKPrompt_Click() Call ObjectVarDeclar Dim Counter As Integer...
  3. OscarAlberto

    Value of Variable does not carry forward

    I define a Dim variable - and give it a value - in one UserForm procedure and within this procedure, call another Module procedure in the same project. The variable does not hold its value when executing the Module procedure. I used a MsgBox to determine that the value when executing the new...
  4. OscarAlberto

    UserForm Type Mismatch Error

    I have code writen for several Textboxes in a UserForm to obtain input from the user. Some of them produce the Type Mismatch Error when I enter a figure, and then Backspace to correct it, or on purpose enter a minus sign (not allowed), to simulate the response from the application, to an error...
  5. OscarAlberto

    UserForm Variable Not Defined Error

    I recently included three new Checkboxes to a UserForm but I get the Error Message of the heading, indicating that the Checkboxes are "Variable not Defined". How can I force the UserForm to recognize new items (Checkboxes, Textboxes) inmediately after being included in the physical form?
  6. OscarAlberto

    Adding Arg's to Application.worksheetfunction.sum()

    Is it at all possible to programatically add arguments to the application.worksheetfunction.sum every time my codes cycles through a Do-Until-Loop???? Thanks in advance.
  7. OscarAlberto

    Private Sub xxxx_Change

    I wrote this code to enter information on cells and to provide the user with inmediate feedback regarding his-her input: negative numbers, non numeric input, empty textbox when input required, etc. I found that the input is made, but after I hit the OK button, the data dissapears from the...
  8. OscarAlberto

    Problem with UserForm "load"

    I have several UserForms that I load with code similar to this, assigned to submenus: Sub ShowEquityPreferredForm2() Call ObjectVarDeclar Load EquityPreferred2 EquityPreferred2.Show End Sub It worked well until - without further input from my part, at least knowingly - I get...
  9. OscarAlberto

    nested If-Then-Else

    I cannot make a large but simple nested If-Then-ElseIf-End If statement. I need to go through several cells from down-up, checking first, if the cell's contents is > 0, and if a number from a previous operation is > 0. The procedure goes directly from the first If to the last End If without...

Part and Inventory Search

Back
Top