1. Z

    Changing VBA code from offset to another sheet

    Hi, I have a VBA code which I found which works great for the purpose of tracking date and time of changes in each cell. I'm wondering if I'm able to change the code to report on a set sheet rather than being an offset. Private Sub Worksheet_Change(ByVal Target As Range) Dim WorkRng As Range...
  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. S

    Time/Date Stamp based on Boolean Value, Formula only.

    Hi Folks, I have a table with upwards of 1000 entries on it and multiple people will be working off this file (not at once). The idea is simple, you check a check box and it adds a time stamp into the "Sent Date" column. Each box is linked to the neighboring cell. However using the NOW() or...
  4. H

    Creating a timesheet in Google sheets and restricting editing.

    Hi, I have a timesheet on google sheets where a timestamp is generated in a cell when someone presses a picture of a clock on the sheet. Is it possible to lock cells so that it rejects all input that is not generated through the timestamp script but still allow specific authorized users full...
  5. C

    Time-stamping existing data with date created

    Hello! I have stumbled on this community and man, do I have a problem that I can not solve by myself! I have a spreadsheet in which I have data in columns A-F that I add to regularly. I recently wanted to update it so that I have a timestamp of when each cell in column A was entered. The issue...
  6. M

    How to set an importance value of multiple variables?

    Hi guys. I'm a bit new in VBA coding, but have worked with Excel a lot. I have this Claim sheet I am working on. And I need the Claim Importance to show (Low, Medium, High) on multiple variables. My formula right now is...
  7. J

    Removing seconds from time string (but only show value??)

    Hello, Ive been trying to figure this out for hours with no luck. I have a column with times listed the format in the cell shows hh:mm but the value in the formula bar shows hh:mm:ss The program i am feeding this information through recognises the actual value (shown in the formula bar) and...
  8. A

    Get different parts of timestamp without MID()

    Hello, I have a spreadsheet with a column containing timestamps (format dd/mm/yyyy hh:mm:ss). I am trying to select certain dates: within a certain month, within a certain year etc. The month I want to select within is selected in a combobox (format yyyy/mm). The way I'm doing it is comparing...
  9. C

    My timestamp functions are being reseting to current date and time when the file is opened by another user or when the data is refreshed

    Dear all . I hope you can help me with the following problem : Have created 2 timestamp functions with VBA , one for the date and one for the time in order to use them when a specific value is changed in a specific cell . For example when data is changed at cell C then cells A & B are...
  10. 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...
  11. B

    Timestamp in Column AC when box is checked in column A

    Hello, I have a sheet with multiple rows of data. In column A there are check boxes. What I need is code that puts a timestamp in column AC when the box is checked in column A of the same row. Column AC is also the last Column of the row if that is helpful. Thanks, new to VBA and trying to...
  12. C

    VBA If Statement Evaluating After True

    Hello: My workbook has 2 sheets, "Numbers" and "General". I have an If statement that runs at workbook close. If Sheets("Numbers").Range("BA2") = 0 Then Sheets("Numbers").Range("BA3") = "Correct" ElseIf Sheets("Numbers").Range("BA2") <> 0 Then...
  13. A

    Error retrieving getting data

    Can I receive assistance resolving an error running this code... The code is suppose to retrieve intraday prices. I email the author, but never received a response. Greatly appreciate the help. Thank you kindly ' Samir Khan' http://investexcel.net ' simulationconsultant@gmail.com ' Contact...
  14. R

    Get value of next non-blank cell above the activecell.row, "O" cell

    Hi all, Have timestamps in column O that can either be blank or non-blank, I'm looking to find the last time stamp in column O If I'm on row 44 in column A, and the last timestamp is on row 41 in column O, how do I say to excel: LastTime = Cells(ActiveCell.Row, "O").Selection.End(xlUp).Value...
  15. M

    Need help in Timestamp format conversion

    I have timestamp under Column A in this format: 2019-06-27T16:05-0400. I want only 16:05 from that timestamp i.e. hh:mm. Can someone help how we can do using macro? Source <tbody> 2019-06-27T16:05-0400 2019-06-27T16:10-0400 2019-06-27T16:35-0400 </tbody> Target: <tbody> 16:05 16:10...
  16. D

    non macro timestamp

    Is there no way to create a timestamp in excel with out using a macro? I really need a timestamp but I have tried using a macro and it just isnt working its more headache than its worth.
  17. P

    Timestamp Help

    Hi, so i am trying to get one last thing working on my work excel before i leave. I have tried a couple of the macros that i have found on this site, but couldn't get them to fully work. So basically i have 12 cells where they update automatically and i am trying to set it up so they also...
  18. C

    VBA question - enter timestamp in more than one cell

    I have the following code that puts an automatic timestamp in Column B when a value is entered into the same row in Column A. HOWEVER, what I need is this: When a value is entered in a cell in Column A, the automatic timestamp is created in the corresponding row of Column B AND Column E. Is...
  19. D

    Shift name based on timestamp

    Hello I am trying to get a shift name based on a timestamp in a different cell. For example if my timestamp says "6/19/2019 13:41:37" I want the word "First" to show up in the next column to identify the shift name. I have searched and searched for an answer to this and cant seem to find it...
  20. M

    VBA code to add time stamp to a list of cells in a column

    Hi I need to write some code which adds a time stamp that will not change to a list of cells in a column. To give a sample example, when a button is clicked, the code would at a time stamp to the beginning of each of the cells below. The data below covers 4 rows, with the numbers 1, 2, 3...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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 MrExcel.com.
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 "mrexcel.com".
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