UserName Property of Application Object VBA

UserName Application Property in VBA is used to sets or returns the name of the user. Please find the more details about UserName in the following section.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

VBA UserName Application Property – Syntax

Here syntax for UserName Property of application object in VBA.

Application. UserName

Where UserName as String.
In the above syntax Application represents object and UserName is the Property of Application object.

VBA UserName Application Property: Example 1

Please find the below example for UserName Property of application object in excel VBA. The below example displays the user name of the application.

Sub Appl_UserNamel()
MsgBox Application.UserName
End Sub

VBA UserName Application Property – Instructions

Please follow the below steps to execute the VBA code to save the excel file.
Step 1: Open any existing Excel Application.
Step 2: Press Alt+F11 – This will open the VBA Editor.
Step 3: Insert a code module from then insert menu.
Step 4: Copy the above code and paste in the code module which have inserted in the above step.
Step 5: Now press F5 to execute the code.


Leave A Comment

Related pages

adding a checkbox in excelunlock locked excel filehow to arrange alphabetically in excelwhere are excel macros storedexcel activeworkbookifs function in excelproject proposal template excelvba excel 2007project timeline template pptmulti column listbox vbaseriescollection vbaprograming excelms access sql server connection stringhow to delete a named range in excel 2010how to merge excel cellsunlocking excel spreadsheetunhide personal xlsbexcel newline in formulabutton excel vbavba datesvba merge cellsdelete all duplicates in exceltypes of column chartsexcel combobox propertiesc basic interview questions and answers for freshersmacro in excel examplefso copyfileexcel chart samplesunprotect cells in excel 2010excel vba savecopyasvba functionsexcel months between two dateshidden cells in excelexcel macro paste valuesmacro delete rowhow to remove duplicate data in excel 2010how to delete doubles in excelvba sqlxlworkbook saveasvba xldownvba offsetlogical operations in excelvba getfilenamedatediff vbavba for excel tutorial for beginnersvariable types in vbavba selected rangecheck if workbook is open vbavba unload userformstring to int vba3d scatter excelwith activesheetsql excel queryexcel how to identify duplicatesvisual basic codingsexcel formula iferrorvba range syntaxexcel vba returnunhide excelremoving duplicates excelexcel vba countifvba create email with attachmentexcel vba check boxproject management excel dashboardexcel formula hlookup exampleexcel 2007 vlookup examplevlookup simpleexcel hyperlinks change to local pathexcel using macrosexcel vba save workbookexample for vlookupunprotect a spreadsheet