Consulting

Results 1 to 3 of 3

Thread: VBA to return ID of person logged on

  1. 08-20-2007, 10:36 AM #1
    Sir Babydum GBE
    Sir Babydum GBE is offline
    VBAX Mentor Sir Babydum GBE's Avatar
    Joined
    Mar 2005
    Location
    Cardiff, UK
    Posts
    499
    Location

    VBA to return ID of person logged on

    Hi

    How do I return the name of the person currently logged on in a message box?

    Thanks
    Have a profound problem? Need a ridiculous solution? Post a question in Babydum's forum
    Reply With Quote Reply With Quote
  2. 08-20-2007, 10:39 AM #2
    RichardSchollar
    RichardSchollar is offline
    VBAX Contributor
    Joined
    Aug 2006
    Location
    Hampshire, UK
    Posts
    140
    Location
    Hi

    One way:

    MsgBox Environ("UserName")
    Richard
    Reply With Quote Reply With Quote
  3. 08-29-2007, 12:35 PM #3
    Sir Babydum GBE
    Sir Babydum GBE is offline
    VBAX Mentor Sir Babydum GBE's Avatar
    Joined
    Mar 2005
    Location
    Cardiff, UK
    Posts
    499
    Location
    Sorry for not thanking you for this sooner!

    Worked great.
    Have a profound problem? Need a ridiculous solution? Post a question in Babydum's forum
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules