-
Capture user data
We have a number of users using a workbook and we want to record who has completed each step and when.
The way the workbook will work is that when a user completes a task they hit a button which stores their user name and date stamp in a separate work sheet.
Does any one have any ideas how we can get user user name?
-
[VBA]MsgBox Environ("Username")
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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