rint

  1. T

    Auto insert date in two cells problem

    Good afternoon, I am really rubbish with VBA so please forgive my code errors. , I have a worksheet where I have a drop down list (A), once selected it puts the date and time in a cell, 2 cells to the right(C). In the same Row I have another cell(F), that if data is present, it puts the time...
  2. M

    Help with VBA?

    I'm using this VBA, and it worked perfectly the first day, but over the weekend I came back to work, and it only works in the cells towards the bottom of the sheet, but not those on the top. I have no idea why it's doing that. Basically, column O is a notes column. Once I make a change in said...
  3. J

    Toggle between colors on right click

    When right clicking within cell range A1 : D4, cell turns green. I want to expand further on this and add that when right clicking on green cell, cell turns yellow. And when right clicking on yellow, cell turns white. How would that look like? And is there a cleaner way by not using Elseif...
  4. E

    Auto Date Entry & Username Entry

    Hi, Could I please aks for some help on the following code It currently places todays date into column B when an entry is made in Column D, this works perfect, What I would like if possible is to add the username into Column C here is my code Private Sub Worksheet_Change(ByVal Target As...
  5. E

    Auto date entry

    Hi, I have the following formula which date stamps into column D when something is entered into column E is there a way to delete the entry if the cell in E has been deleted Many thanks Private Sub Worksheet_Change(ByVal Target As Range) Dim rInt As Range Dim rCell As Range Dim...
  6. R

    Insert Username Stamp in cell

    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...
  7. J

    macro

    how do I change the below to not be an event, but run from a macro1? thanks Jan Private Sub Worksheet_Change(ByVal Target As Range) Dim rInt As Range Dim rCell As Range 'change the input cell range as desired Set rInt = Intersect(Target, Range("plus20pct")) If Not rInt Is...

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
Back
Top