rint

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

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

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

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

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

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

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