Hello!
I am trying to set up a form that will pull data based on who opens the file. I was able to find code to pull the username upon opening the document and display it in a message box. But i would like this info in cell "B2" instead of a message box.
I have attached a blank file that has the VBA to display in a message box. Can anyone assist in getting the username to display in the select cell instead? any help is very much appreciated!
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or maybe thisPlease Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Thank you! thats exactly what I was looking for!
You're welcome. Thanks for the rep.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks