Search:

Type: Posts; User: erik.van.geit; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.35 seconds.

  1. Replies
    19
    Views
    12,252

    Re: Creating a simple time clock macro

    You're welcome!
    I hope you will enjoy your journeys on this board and learn a lot :-)
  2. Replies
    19
    Views
    12,252

    Re: Creating a simple time clock macro

    Hi
    Welcome to MrExcel!

    It is risky to respond to old threads. Probably only a few people will see your post.

    You can take a look in the VBA help files for "Format". It would even be inspiring...
  3. Replies
    6
    Views
    267

    Re: Match 7 columns of Data

    you're welcome!
    how did you change

    Set RangeToAlign = Range("A2:G6")
    Do not select the headers.

    The trouble is probably

    .Offset(-1,0)
    this can not be done when the range contains row 1
  4. Replies
    6
    Views
    267

    Re: Match 7 columns of Data

    Hi, Bribbin,
    WELCOME to MrExcel!
    Mick has already answered, which I didn't see in time, but anyway I'll post my code too.

    'Get values from all columns to the same row
    'values will be in order...
  5. Replies
    16
    Views
    801

    Re: strange behaviour in UserForm code

    Yes, Dave, works for me too. Thanks.

    I still would use Rorys suggestion, because that fix seems more logic to me, it makes more sense within code.

    .List(.Listindex)
  6. Replies
    16
    Views
    801

    Re: strange behaviour in UserForm code

    Thank you, Dave, I tried some variations on the theme using "activate", but that didn't lead to anything for me in this case.
  7. Replies
    16
    Views
    801

    Re: strange behaviour in UserForm code

    Hello Rory,
    Thank you for your input: it is a useful not to difficult workaround.

    So you did experience this problem before, I guess, else you wouldn't use the code construction:...
  8. Replies
    16
    Views
    801

    Re: strange behaviour in UserForm code

    Would it be worth to post this to Microsoft?
  9. Replies
    16
    Views
    801

    Re: strange behaviour in UserForm code

    Sektor,
    Thank you for your input.

    Another thing I did not write in the original post: when I checked the problem the day before, I got "empty" with:

    MsgBox ListBox2
    (or Debug.Print)

    So,...
  10. Replies
    16
    Views
    801

    Re: strange behaviour in UserForm code

    Hi, Andrew
    Thank you for your answer. Well indeed, the value does the thing for me too.
    Still wondering what happens...

    beste regards,
    Erik
  11. Replies
    16
    Views
    801

    Re: strange behaviour in UserForm code

    Hi, Rick
    Thank you for responding.
    Using Excel 2010 too.

    I added this to my post while you were typing.:

    Did you try a few times?

    This is very wierd: can't remember that I ever had such a...
  12. Replies
    16
    Views
    801

    strange behaviour in UserForm code

    Hi,
    Happy New Year!

    The following occured within a file and I can replicate this error in new files.

    I created a userform with 2 listboxes and a button.
    Then pasted this code

    Private Sub...
  13. Replies
    4
    Views
    1,204

    Re: error -2147417848 (80010108)

    Graag gedaan!
    GELUKKIG NIEUWJAAR!!
  14. Replies
    4
    Views
    1,204

    Re: error -2147417848 (80010108)

    Hallo
    Is mijn antwoord jou ontgaan?
    groeten
    Erik
  15. Re: VBA to move rows to another sheet based on criteria

    Hi, tournapart
    Welcome to the MrExcel!

    You responded to an older thread; your chances to get response are reduced. i''ve currently no time to take a look at your request. You would better start...
  16. Replies
    11
    Views
    29,591

    Re: Refresh a Currently open Excel Sheet?

    You're welcome!
    Just saw your signature:
    I Envy The Person Who Knows Excel All The Way.
    You would envy a person which does not exist :-)

    Have a nice day!
    Erik
  17. Replies
    4
    Views
    1,204

    Re: error -2147417848 (80010108)

    Hallo

    Rory heeft mooi code-tags ingevoerd: gebruik het "kruis" teken # in de werkbalk. (bij Quick Reply is dat helemaal rechts)
    Ik vermoed dat je bedoelt dat Excel crasht; klopt dat?

    Kijk hier...
  18. Replies
    10
    Views
    1,973

    Re: bizarre dans excel

    N'ayant pas beaucoup de temps ces dernières semaines pour venir ici ... bon bref :-)

    En fait la solution est probablement toute simple. Les références vers d'autres feuilles provoquent le mauvais...
  19. Replies
    11
    Views
    29,591

    Re: Refresh a Currently open Excel Sheet?

    Hi

    Both codes have not the same purpose.

    Your code cannot be run from the workbook itself. You code, if place in the workbook "Db.xlsb" would stop running with the "close" line.
    My code is to...
  20. Replies
    10
    Views
    1,973

    Re: bizarre dans excel

    Pardon, Patrick

    Etant très occupé ces derniers temps, j'ai perdu de vue ceci. J'ai le même problème, essayé divers trucs, mais pas trouvé de solution.
    J'appele au secours chez les MVPs.
    ...
  21. Replies
    10
    Views
    1,973

    Re: bizarre dans excel

    Je n'ai toujours rien reçu.
  22. Re: selectionner le texte d un textbox ou positionner curseur

    Bonjour

    Vérifiez les propriétés
    SelStart
    SelLength
    et peut-être
    SetFocus

    With TextBox1
    .Value = 24
  23. Replies
    10
    Views
    1,973

    Re: bizarre dans excel

    On a poursuivi en PM, mais depuis mon dernier message il s'est passé un bon bout de temps. J'espère qu'il ne s'est pas perdu.
  24. Replies
    10
    Views
    1,973

    Re: bizarre dans excel

    Bonjour, Patrick

    Je ne peux pas reproduire ce problème; Ages et Départements restent corrects après avoir trié la plage.

    Les formules réfèrent aux entêtes; as-tu essayé d'utiliser des formules...
  25. Replies
    15
    Views
    9,481

    Re: Auto enter in Excel

    Hi, RosieRose

    You replied to a 6 year old thread; perhaps you didn't notice because of the two more recent posts just before yours.
    Not sure if I understand your question exactly; I see some...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4