1. R

    VBA fOSUserName 64 bit - 32 bit issue

    Hi The code below is meant to retrieve the username in a cell with the formula =fOSUserName() The code works flawlessly on my private desktop with Excel 2019 64 bit. However, the code does not seem to work on my company's desktop with Excel 2016 32 bit, even though the code works on this 32...
  2. M

    Insert username in a cell, based on cell value

    Hi everyone How am I able to insert the username in the column "Closed by" and the actual date in column "Date for closing Claim Internal"? I tried with this VBA code, but it only take line 31. Private Sub Closed_by() If Range("AJ31") = "Closed" Then Range("AK31").Value =...
  3. A

    Extract Name after comma (Username)

    Hi Team, Please note I am trying to put in place a welcome message in userform (label) but the application username needs to be restricted to only show the Name of the user ( That it is after the coma) The code is working correct but unfortunately I need to extract only the value after the ","...
  4. A


    Hi! I have a table that I put into a subform so users can fill out portions of the data. The user will review the work and write in who is responsible, the credit category, cause, and notes. I want to hide the TINITIALS (username) and STAMP (time stamp). I want to use an Event, but I can't...
  5. F

    Auto fill date and name of users when they change cells in a row.

    Hello I have been trying to find a macro that autamatically fills 3 different cells with date, updated date and name of user, when someone fills certain cells in a worksheet. i have 2 macros that work independently. but i cant make them work together: (Optimally i would like to have the macro...
  6. T

    Open de File with a sheet filtered according to a matriz

    Hello specialists, I have a sheet called "Data", and there from row 4 and along, I have several collunms with data, like "Main Responsible" in AO, "Country" in AK and "SBU" in AL; I am also have another sheet called "AuthUsers", where I've created the below matriz; soo, I am looking for a VBA...
  7. L

    Excel to log name, date and time somebody accessed a report on a network drive....

    Hi, I’m looking for help logging in Excel, using VBA to log in ahidden sheet the username, date and time logged in and logged out of reports inshared locations. I know a solution exists because I’ve used one before, but Ican’t for the life of me remember how I did it… Does anybody have...
  8. Y

    Macro to copy values across rows and transposing them and add the user id

    Hi, I wonder if someone can help me with this problem with amacro. I have a table of data that appears below(input data) whichhas usernames down a few rows and one or more accounts across 70 columns. On a regular basis, I would need to able to copy all theaccount numbers that are present...
  9. M

    VBA event to 1) print now, 2) print username & 3) prevent deletion

    Hi guys, I hope everything is going well with you. Look, I need your help please. I need to create Save event. So, once the active sheet is saved, the code acts as follows: Type the date and time (NOW function, I believe) in the active row, second cell (Column B). Type the username (Environ...
  10. R

    Date & Username Stamp Help

    Hi, I a pretty new to VBA and would like some support. What I looking for is a piece of VBA code that will date stamp Column O Username Stamp Column P, based on the status in column K being changed to either - Resolved & Ignore/Resolved. Ideally id like the O & P cells to be locked down an...
  11. L

    returning date and username if statement is true

    I have an excel sheet that tracks documents that have been reviewed by project managers. When a PM reviews a document they select "Yes" from a drop down (only way i could figure out to limit data entry). What I am looking to do now is two seperate actions. 1. If "Yes" is in Cell D23 (the whole...
  12. M

    Paste Vales in same row, different columns

    Hello, I would like to paste 3 values in 3 columns A, B, and C in the last available row. Filename = Dir(Path & "*.xls*") DateTimeStamp = DateTime.Now UserName = (Environ$("Username")) 'get last AVAILABLE cell to paste into Set iLastCellS2 = s2.Cells(s2.Rows.Count, "A").End(xlUp).Offset(1, 0)...
  13. R

    VB Invalid use of property

    I don't know why I keep getting this error. I've tried BeforeUpate,AfterUpdate, enter,exit....none of them work. HELP, please Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean) Dim Username As String Username = TextBox2.Value MsgBox "Hello, " + Username + "...
  14. V

    How one can download reports from web through excel which is required credentials to proceed?

    Hi, I am looking for below. I want to extract reports from web which is having to username and password. How I can start with? Let me know. Nee
  15. G

    Fuzzy logic Lookup using start/finish date & time and other text

    Hi, I am trying to look up two data sources and would really appreciate any help please: Call Data <tbody> Username Start End Call Id name1 01/04/19 08:01:07 01/04/19 08:13:19 100001 name2 01/04/19 08:01:45 01/04/19 08:07:12 100002 </tbody> against Interaction Data <tbody> Username...
  16. countryfan_nt

    Run code if Username match And current time is between 2 sets of time.

    Hello friends, hope all is well! Can you please help me with the code below: I want the code to close the workbook if: 1. UserName is NOT Johnny Case AND 2. Between times 17:45 and 17:59 OR 3. Between times 07:45 and 07:59 The code is placed below; thank you very much in advance...
  17. Knockoutpie

    How do I rearrange columns based on cell value and not headers?

    Hi everyone, Is there a way to rearrange the columns based on values in the cell and not based on the headers? for example the first rearrange would be Username, Hint, Password, Site, the second rearrange would be Password, Username, Site, Hint. If i'm not being clear enough, please let me...
  18. W

    Login on website with Username and Password

    Hi All, I'm practicing VBA for a while now as a hobby and I want it to take a stepfurther. I want to extractdata from a website but the first step is login. Do you know howI’m able to login with username and password on the website below? Thanks...
  19. W

    If Username is not true then open a userform

    Hi. We got a excel program, which uses: Worksheets("39").Range("Z100").Value = Environ("Username") with adds the users usernames into a cell (Z100), which customizes their experience depening on who they are (userform). But i am wondering. Is there a way to add it so, if a user which is not...
  20. J

    Lock Range of Cells Using Command Button

    Hello, I'm new to MrExcel and could use some help with the following situation: Person 1 enters data in single row, various columns A through O, then hits a "process" button that I've inserted using ActiveX Controls. Their username and date/timestamp populates into that row, column Q. Person...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back