Search:

Type: Posts; User: Trixterz; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Generic MouseWheel Scroll for UserForm and for ALL its Controls !

    You Sir are a genius, thank you so much for your contribution. The demo was flawless.
  2. Replies
    29
    Views
    721

    Re: Sum in selected cell

    Change the letter B to A should fixed the issue.



    Dim Results As String
    'Gets value from column A.
    Results = Range("A" & ActiveCell.Row).Value
    Results = (Results + (Results *...
  3. Re: Application-defined or object-defined error

    There is one way to test it, try using this code on it...



    Dim MyArray(1 To 15000, 1 To 50) As String
    Dim Rows As Integer, Cols As Integer


    For Rows = 1 To 15000
    For Cols = 1 To 50
  4. Replies
    29
    Views
    721

    Re: Sum in selected cell

    Or this...



    Dim Results As String
    'Gets vaule from colume A.
    Results = Range("A" & ActiveCell.Row).Value
    Results = (Results + (Results * 0.1)) / 2 + 0.5

    'Post...
  5. Re: VBA to create new tab based on each change in....

    You can easily do this using pivotTable without having to write a VBA script.
  6. Replies
    5
    Views
    228

    Re: Print using a userform

    Why don't you show us what you have so far so that we might be able to help you along?
  7. Replies
    5
    Views
    125

    Re: IF Statement - brain fog!

    =IF(G4=E4,F4,IF(G4>E4,SUM(C4-D4*G4),"what to do if false?"))
  8. Replies
    13
    Views
    420

    Re: userform editing & listbox issue

    If you want the zeros to show in front of the number then you need to change the number format of your cell or use the code below to replace your cmdEdit_Click sub routine in your registration form....
  9. Replies
    13
    Views
    420

    Re: userform editing & listbox issue

    Can you be more specific?
  10. Replies
    11
    Views
    265

    Re: urgent - nested ifs

    Try this...


    if Range("B1:D1").value=empty then Range("A1").value="Pass"
    elseif not Range("B1").Value=empty and Range("C1:D1").value=empty then Range("A1").value = "Fail"
    elseif not...
  11. Replies
    13
    Views
    420

    Re: userform editing & listbox issue

    I found what was causing your error and provided a fix for it. The issue was that your look for a staff ID that does not exist because you changed it in reg4.

    Use this code to replace that one in...
Results 1 to 11 of 11