Results 1 to 5 of 5

Add Windows User Name to Cell

Threaded View

skydivetom Add Windows User Name to Cell 03-23-2020, 10:04 PM
Logit Re: Add Windows User Name to... 03-23-2020, 11:04 PM
skydivetom Re: Add Windows User Name to... 03-24-2020, 03:16 AM
Logit Re: Add Windows User Name to... 03-24-2020, 07:27 AM
XLent Re: Add Windows User Name to... 03-24-2020, 07:52 AM
  1. #1
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    367

    Add Windows User Name to Cell

    Experts:

    Attached is a sample spreadsheets which includes a validation process checking whether or not all five (5) questions have been answered (prior to closing XLS).

    As part of the XLS closing process, the validation throws a message including the user's name plus the questions which are still unanswered.

    Here's what I need some help with:
    - Upon opening the spreadsheet, I want the Windows username (see validation message) automatically added into cell F1 (independent from having answered the questions). What VBA needs to be added which will insert the value? Once that's working column F will be hidden (merely for tracking who submitted what information).

    Thank you,
    EEH
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Get user windows password using VBA
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-25-2018, 10:53 AM
  2. bring the Windows user name
    By shimaa01234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2015, 01:10 PM
  3. [SOLVED] Windows 7 user account notifications and VBA...
    By swoop99 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-23-2012, 04:47 AM
  4. Windows User Name in a Cell in Excel SpreadSheet
    By dr.fahadamir in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2012, 05:00 AM
  5. Insert user's name into cell based on windows user login when a button is clicked.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-16-2011, 01:08 PM
  6. SQL Statement WHERE User = Windows Username ID
    By JohnGaltnl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2011, 04:24 AM
  7. Pop Up Box that recognises the Windows User Logged On
    By krishatherley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2009, 09:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1