Sliding userform example

  • Re: Sliding userform example


    Thanks Trunten - yup... works fine in Excel 2007 :)


    BUT... it did fail for me on a 64 bit version of 2010... complaining about the usual "ptrsafe" requirement. You just need to be a little careful when using API calls in 64 bit environments and use a compiler directive - the following seemed to work well for me on both 32 bit 2007 and 64 bit 2010:


    Code
    1. Option Explicit
    2. #If Mac Then
    3. MsgBox "Go away"
    4. #ElseIf Win64 Then
    5. Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
    6. #Else
    7. Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
    8. #End If


    That being said, I doubt many people have 64 bit office installed as the 'default' during installation is 32 bit.


    Ger

    Check out our new reputation system. Click on the Like button under the post!
    _______________________________________________

    [SIZE=8px]There are 10 types of people in the world. Those that understand Binary and those that dont.


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...


    The BEST Lookup function of all time


    Dynamic Named Ranges are your bestest friend[/SIZE]
    _______________________________________________

  • Re: Sliding userform example


    :) That being said, I do love my new ipad thinggy :)

    Check out our new reputation system. Click on the Like button under the post!
    _______________________________________________

    [SIZE=8px]There are 10 types of people in the world. Those that understand Binary and those that dont.


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...


    The BEST Lookup function of all time


    Dynamic Named Ranges are your bestest friend[/SIZE]
    _______________________________________________