username

Good Afternoon, I have created a worksheet which will insert the date and time in column B when each row is entered. I would like to now add (stamp) the windows username to the same cell if possible. This is the current code I run and would sincerely appreciate any help. :confused: Private...

There is a website I am trying to use VBA to input the Username and Password and then "Click" the submit button. I was successful in placing the Username and Password into the appropriate fields, but I can't get it to "click" on the Login Button. This is the website...

Morning, Is it possible to use a macro to detect your username and then select that username in a slicer

I have recently started using Environ("Username") quite a bit. I use it to track who's using my workbook, or track issues certain users may be having, and also to make a few of my userform functions a bit more user friendly. I've been having these strange issues with my workbook that I had not...

I have a list of Usernames in column K. When a user opens the workbook I have code that checks that list, and if the current user ( Using Environ(Username)), isn't on the list it adds the user to the end of the list. If the username is already in the list it does nothing. It works great, but it...

Hi, I have two worksheets sheet 1 sheet 2 In sheet 1 I a have two cells that I would like to autofil with username and timestamp when data is changed on sheet 2. A1 = username A2 = timestamp If anything changes on sheet 2 I need A1 and A2 to have the username and timestamp automatically...

Hi all, Is there a way to have the username and date displayed together =username()&NOW() displays a number after the username Thanks for any help

I am using the above to place the users information within the sheet. However, I have many sheets within my workbook and unless the actively click on the cell it doesn't populate that cell. Is there a VBA or macro that will engage this on all sheets updating all fields with Username() to that...

Hello, I'm newbie to all these "programming" excel and access things, so i needed some sort of database. I look at some tutorials, find some templates on internet and just edit it to fit my need's. I have the following problem: I created Login Form Code: Option Compare DatabasePrivate Sub...

Hello All, I have this challenge here: i wanna find out if what i am thinking is possible. Then after that i need help with it. So i have a textbox called txtCurrentUser and in this textbox i have username in it. Now i wanna write a script to look at the txtCurrentUser, counting from the left...

We have a Excel spreadsheet to control and manage our company archive, only certain people have permission to edit and add to the spreadsheet across the company and I'm currently in the process of upgrading this to give us more visibility. I'm after a way to show in cell A2 the date the...

Hi, Can anyone help with this code? I cant seem to make it work correctly. I am trying to find cell (A1) value's match in range ("B:B"). And then populate sheet 4 (report) column D with the corresponding username found in sheet 2 Associate Table. I have a table, sheet 2 which has cell A1 RFID...

Hi Guys, I hope you are all well. I was just wondering if anyone can help me I am just looking for a simple sub that simply puts the Application.Username in column E and Date and Time in Column F each time the macro is used and will create a list of Users And Login Times. any help would be...

I am a beginner and need things outlined very detailed. I am creating a file for scheduling. In the User tab, in column A I have Admin User Names. I have a code written that in C4 "Username" cell it displays the username of the person. This is from the network. I want to write a code that will...

I found this code searching forums and I have a specific use for it and I am trying to get it to function. I have only made minor changes to it so that it recognized the user row to determine which sheets to unlock. The idea is to prompt for username and password and then unhide the sheets that...

Good morning folks, I am trying to populate excel/windows username in a cell and using following formula: Sub GetUser() Range("Q299").Value = Environ("UserName") End Sub Sub GetUser() Range("Q300").Value = Application.UserName End Sub But it's not working. Any suggestion?

I'm not finding a solution to my problem. At work I have a shared worksheet saved in the server and I need a macro that displays the name of the active users.

Hey guys, Is it possible to save or write an user name to a cell, if that user changes a value? <tbody> A B 1 value w 2 value x 3 value y 4 value z </tbody> If user changes 'value w' (change: to another text, string, or even delete the value), B1 should show user name. If user...

Hi Guys, I have been trying to create a VBA change log for days now, without any luck whatsoever. I have a workbook that contains several sheets, and I want to log every change that is made to a cell within the workbook The information I want to log: Username (excel username), Date, Time...

Hey Guys, Probably something that isn't very hard. I have actually found out how to do the User Name. VBA: Username = Environ("UserName") Cell Formula: =Username() This takes care of the Username. I can't, for some reason, find anything online about grabbing the workbook's author(s) name...