1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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.
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. R

    Issues with timestamp now()

    Hi All, Any help attained would be great, I am not the best using VBA so hence the query. I have a sheet where users submit their completed work and a cell calculates the % of work done. I have 4 other cells that have % thresholds from 25%/50%/75%. Is there a way for me to have a timestamp...
  17. V

    Macro transform all notes into comments

    Hi all, Excel 365 here. The newer Excel version changed the old “comments” as “notes” (renamed this way), and added a new feature under the mention “comments”, which works like a thread with possible replies, where on top of input text, the autor is mentionned with a timestamp. I’d like to...
  18. mikecox39

    Timestamp shortcut format missmatch

    I set the cell format as time and 24 hr. So, when I enter 21:10 the time displays in the cell that way and if I enter 9:10 p the time displays as 21:10, just as expected. However, when I use the timestamp shortcut (Ctrl+Shift+:) the time displays as 9:10 pm. How do I force the timestamp...
  19. A

    Add 1 hour to Timestamp with if statement

    I want to add 7 hours to timestamp if time is 01:00:00AM and add 1 hour if it's not 01:00:00AM. I tried - if(A2=TIMEVALUE("01:00:00AM"),A2+TIME(7,0,0),A2+TIME(1,0,0)) A2 = <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>08/Jan/19 8:0:0AM 1...
  20. C

    VBA Format Cells Based On Data

    Greetings! I'm a real newbie to VBA and I have been stumped by this formatting of cells. I have Excel files (lists for gages due calibration) that we post for production. These lists are Excel files generated daily by our gage management software. I have a macro that opens each file and...

Watch MrExcel Video

This Week's Hot Topics

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