98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft Excel 2003 Populating Cell With Login Name!
Microsoft Excel 2003 Populating Cell With Login Name!
Resolved · High Priority · Version 2003
Sat 12 Jul 2008, 10:49Delegate Dee said...
Dee has attended:
Access Intermediate course
Excel Advanced course
Visio Advanced course
Microsoft Excel 2003 Populating Cell With Login Name!
How do I populate an Excel cell in a spreadsheet with a my user login name from Windows XP?
Thanks,
Dee
Sun 13 Jul 2008, 17:09Trainer Pete said...
RE: Microsoft Excel 2003 Populating Cell With Login Name!
Hi Dee,
Thank you for your post,
This can be done using a little VBA;
in the VBA module type the following and save it:
Sub Username()
Range("A1").Value = Application.UserName
End Sub
Save and then in your chosen cell type =username()
I hope that helps for you, regards Pete
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Deleting cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + -. |
