Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.26 seconds.

  1. Re: adding a splash screen to an existing user form app

    Hello, try this, place the following in the UserForm1 Module:



    Private Sub UserForm_Initialize()
    Application.OnTime Now + TimeValue("00:00:05"), _
    "KillTheForm"
    End Sub

    And place...
  2. Replies
    3
    Views
    314

    Re: Question regarding Offset

    Hello, you're welcome.

    Well, if I understand the issue properly, I'd set the subsequent finds as Ranges and work from there, e.g.,



    Sub foo()
    Dim cl As Range
    Set cl = Range("A1")
    MsgBox...
  3. Replies
    3
    Views
    314

    Re: Question regarding Offset

    If you're going to do it like this, which I don't recommend, you need to treat your Offset as a String. E.g.,

    MsgBox Range(Range("A1").Address).Offset(0, 4).Address

    *Untested*

    At a...
  4. Thread: guitarist

    by NateO
    Replies
    38
    Views
    3,225

    Re: guitarist

    If you're into the Banjo, you need to get some Bela Fleck going on!

    http://www.youtube.com/watch?v=ViA6OJB3JgI

    Vic's pretty unreal on the bass, too! :)
  5. Re: adding a splash screen to an existing user form app

    Hello,

    Without having watched the video, have you seen J-Walk's page on this?

    http://j-walk.com/ss/excel/tips/tip39.htm

    You want the OnTime Method.
  6. Thread: TEXT and format

    by NateO
    Replies
    4
    Views
    259

    Re: TEXT and format

    Does something like this work?

    =FIXED(A1,1,TRUE)&" years"

    The Round() function should work...
  7. Replies
    23
    Views
    2,037

    Re: Idiotic policy on signatures

    Hi Jennifer,

    You're not being treated as a spammer, just as an unknown person who we're getting to know better. :)

    Spammers don't just lose signatures, they lose account privledges. ;)
  8. Replies
    2
    Views
    287

    Re: Worksheet change event

    Hello,

    It works fine for me, what Range are you deleting?
  9. Replies
    7
    Views
    487

    Re: Parameterized use of the match function

    So you have it backwards? Flip the first and second argument.
  10. Thread: guitarist

    by NateO
    Replies
    38
    Views
    3,225

    Re: guitarist

    Never too cool for school! :)

    You have to mix it up, though. I showed up at concert early, was wandering around the pool tables, and thought "Holy [censored], that's Jimmy Herring!" And he was...
  11. Thread: guitarist

    by NateO
    Replies
    38
    Views
    3,225

    Re: guitarist

    :eeek: :confused:

    That's blasphemy! Hendrix was an amazing guitar player - he practically invented 8-track recording. And his 1-track recording was pretty solid, too. To properly play 'Little...
  12. Replies
    14
    Views
    801

    Re: For loop / Array Question

    Coerced Byte Arrays will always give you a 0-based Array, too. E.g.,



    Option Explicit
    Option Base 1

    Sub foo()
    Dim b() As Byte
    Let b = "Hello World"
  13. Replies
    5
    Views
    433

    Re: Importing range into 2d array?

    Hello,

    Something like this perhaps?



    Sub foo()
    Dim varArr() As Variant
    Dim i As Long, j As Long
    Let varArr = Range("A1:A10").Value
  14. Re: userform textbox using vlookup date could not give correct answer (40850)

    Hello,

    Format the VLookup return, e.g.,



    Format$(WorksheetFunction.VLookup(txtStudentName.Value, Sheets("SPANISH").Range("A2:F113"), 5, 0), "mmmm d, yyyy")
    *untested*
  15. Thread: Slow VBA Code

    by NateO
    Replies
    8
    Views
    754

    Re: Slow VBA Code

    Also, what does this do?



    Call ShowDetail
  16. Replies
    14
    Views
    801

    Re: For loop / Array Question

    Please don't call me Mr., Nate is all good, I didn't mean to be rude. Go ahead and write it for him - although I'm not sure why, it's pretty easy.
  17. Re: userform textbox using vlookup date could not give correct answer (40850)

    Just format it. Excel stores dates and times as numbers, the Worksheet Cell is simply a formatted mask. So make your own mask for the UserForm, with Format$(), as shown.
  18. Replies
    14
    Views
    801

    Re: For loop / Array Question

    A small comment, your Array actually has six elements, so it might make sense to declare it as 1-based, e.g.,



    Sub EArray()
    Dim strArr(1 To 5) As String, msgVar As String
    Dim i As Long, num...
  19. Re: userform textbox using vlookup date could not give correct answer (40850)

    Hello, try formatting the number with Format$(), e.g.,



    MsgBox Format$(40850, "mmmm d, yyyy")
    MsgBox Format$(40850 + 20, "mmmm d, yyyy")
  20. Replies
    10
    Views
    574

    Re: Separate a string

    You're quite right, Rick. I didn't think through my response closely enough, while we both seem to agree there might be a problem...

    The only way I see a solution to this problem is that the...
  21. Replies
    10
    Views
    574

    Re: Separate a string

    You might end up with a problem in C1, too. Try this:

    =DATEVALUE(TEXT(TRIM(MID(SUBSTITUTE(A1,"_",REPT(" ",LEN(A1))),LEN(A1)*1,LEN(A1))),"0-0-0000"))
  22. Replies
    10
    Views
    574

    Re: Separate a string

    Notice a trending change in the functions? Try changing E1 to multiply by 3 instead of 2.

    Still, why not use Text to Columns? It's vastly more efficient, and you won't have to worry about syntax...
  23. Replies
    45
    Views
    2,175

    Re: Finding highest drop in value

    Hola, that is the formula - give it a shot.
  24. Replies
    45
    Views
    2,175

    Re: Finding highest drop in value

    Hello, try this:

    =MIN(C2:C5000)
  25. Replies
    7
    Views
    487

    Re: Parameterized use of the match function

    Are you sure you don't have it backwards? This works fine for me:



    MsgBox WorksheetFunction.Match( _
    Range("foobar")(1, 1).Value, Range("A1:A10"), 0)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4