Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel populating

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!

ResolvedVersion 2003

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

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

Excel tip:

Apply Autosum with keyboard shortcut

If you press Alt and = at the same time, it applies autosum.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.