1. Agnarr

    Checkbox Timestamp with VBA

    Hello everyone! I have a huge problem. we utilize a "to-do" list with checkboxes that are inserted into each new sheet with the following code: Sub InsertCheckBox() Dim rng As Range Dim chkBox As CheckBox Dim cell As Range Dim i As Integer ' Set the range where you want...
  2. J

    Save outlook attachment without file extensions

    Hi all, Hoping this is a simple fix. I have the below script that I found on another forum that runs as a rule in Outlook to save .pdf email attachments with a timestamp that come from my printer. That part all works fine. The problem I'm having is that it will save the file with the .pdf as...
  3. Agnarr

    Refining VBA code

    Hello everybody and you all do an amazing work. I need your help please and i apologize in advance for any mistakes (English is not my native language). So, I have made the following: In B column appears a timestamp when in column C somone inputs a code which automatically reaplaces it with a...
  4. F

    Calculate band on Hours/Time passed

    Please help me out to figure out a formula to calculate Date/Time Base Bins (See attached Image).Whenever The ID Creation(Column A) on Current Day and Time 3:00 PM to 6:00 PM, In Column C "> 3 to 6 PM" , Current Date and time between 6 to 7 PM in Column C result should be " > 6 to 7 PM", after...
  5. R

    How can I compute total time of an excel sheet?

    I need to compute the total time in which a system was down, and it looks like using the SUM(C1:C20298), it's not working for me, it's giving me some results that are not accurate.. The problem is that I have random timestamps like 17:27:22.432, then 08:04:25.532, and those are over 24h, so it's...
  6. M

    Highlight duplicate values with conditions

    Hi everyone, Thanks for reading my post, I'm looking to highlight duplicate values within 24 hours from the previous duplicate value. I'm using this but this is not what I want, I would like to replace NOW() with the timestamp of the previous duplicated value (if exist)...
  7. L

    Time based graph

    Hi, Is it possible to create a time based graph in Excel where I can plot a bookmakers odds against the Timestamp (Timevalid) on the axis and the odds on the y axis? I would like to define which Bookmakers to include in a filter for the graph (is this a pivot graph?) as well as which selection...
  8. 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...
  9. 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 =...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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