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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by OscarAlberto

  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 tried both suggestions and didn't work. Keep thinking, and again thank you in advance.
  3. 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...
  4. OscarAlberto

    Value of Variable does not carry forward

    Please clarify, since I am new to VBA (and programming as a matter of fact)
  5. 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...
  6. OscarAlberto

    UserForm Type Mismatch Error

    The Checkboxes are for the user to choose from two or three options, like liquid, solid or gaseous. Then the textboxes provide an area to input say, temperature, but it cannot be negative (-), or more than a certain maximum number, it cannot contain symbols, or be empty. I would really like to...
  7. 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...
  8. OscarAlberto

    UserForm Variable Not Defined Error

    I tried inserted a Toggle Breakpoint, and it's pointing to the code inmediately before the one I just posted, which refers to one of the new TextBoxes: If ((Not IsNumeric(TextBox2)) Or (TextBox2.Value > Assumptions.Range(&quot;ConcessPer&quot;)) Or _ (TextBox2.Value <= 0)) Then
  9. OscarAlberto

    UserForm Variable Not Defined Error

    Unfortunately, after I posted the questions I got a &quot;Fatal Error&quot; prompt and couldn't save my work up to the point where I got the Variable Not Defined Error Message. Now I get a &quot;Type Mismatch&quot; and the following code is highlighted: Msg = MsgBox(vbCrLf & vbTab & _...
  10. 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 &quot;Variable not Defined&quot;. How can I force the UserForm to recognize new items (Checkboxes, Textboxes) inmediately after being included in the physical form?
  11. 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.
  12. 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...
  13. OscarAlberto

    Problem with UserForm &quot;load&quot;

    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...
  14. OscarAlberto

    nested If-Then-Else

    Thank you. It seems the problem was that I was using more than one And after each If. Is that how it works? No way to test a number, cell content, etc. more than twice with And?
  15. 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...
See more

Part and Inventory Search

Back
Top