changed

I have some text and digit in A1 to J1, but i want that if i type "O.K." in K1 then all line A1 to J1 changed to Blue Color.

Hello everyone, Couldnt seem to find the correct formula for what I am trying to do. In Column O There will be a Yes or a No depending on Checkbox selection on userform. Say cell O2 is entered or changed to true then I want cell P2 to have a non changing date stamp. here is a screen shot of...

I have created a multi-sheet workbook with several VBA codes running and I want to make sure people can't mess it up. Is there a way to make sure people can only input information into certain cells and run the codes from the buttons?

Hi, Working on a spreadsheet containing VBA, last night, closed it and it contained 1 Workbook object (ThisWorkbook) and several Worksheet objects) Today, in the Project window, two worksheet objects have changed icons and showing as Workbook objects?! This is causing an issue with a save...

Hi I have workbook which has worksheet called hello or sheet1(hello) that is how it looks like in the vba project window. The code below does not work because of Workbooks(1).Sheet1.Activate but if I changed it to workbooks(1).worksheets("hello").Activate it will work! Why is that? thank...

I need to change the cell text format to RED if the value of the cell is changed (not formatting or just clicking in it). Additionall, when the cell is changed in a row, a column at the end needs to show the date last changed (mm/dd/yyyy) and name of computer that changedit. Is this...

Hi I highlight cells A1:A3 and changed the format to Text. Then I entered time <tbody> 1:00 2:00 3:00 </tbody> They are all aligned to the left. So far so good. Then I highlighted them again and changed the format to Time. Nothing changed!!. What I needed to do is to double click on...

Hi I want to convert time to general (number). I want the numbers to be appeared like this 1/24, 2/24, 3/24,...., 24/24 I changed times to fractions format but I did not get what I want. In some cases like 10:00 pm, the fraction format changed it to 1 instead of 22/24. Thank you very much...

Hi I have a cell D4 which has value = 40:03:28 The value is aligned to the right side of the cell, which gives me an impression it is a number, right? When I one click (select) that cell. I see the following: cell value = 40:03:28 Formula bar = 40:03:28 Home tab-->Number group --> I see...

I'm not sure this question is going to make sense, but please bear with me: I have my task list in Excel. I have 29 columns of data (some of it task-related, some of it formulas to manipulate that data). When I complete or cancel a task, I don't delete it - I move it to the "Completed" sheet...

hi, I use the following code Dim Changed As Range, Cell As Range Dim Clr As Long Set Changed = Intersect(Target, Range("m2:k300")) If Not Changed Is Nothing Then For Each Cell In Changed Select Case LCase(Cell.Value) Case "win10": Clr = 35 Case "no"...

Hi All Randomly my excel has changed CTRL + ; from todays date to ... When i go into options there is no option for keyboard shortcuts. Has anyone any ideas how to revert this back? Checked a colleagues version and only difference I have is having fuzzy lookup installed. Thanks!

I have tried to follow an answer that you gave a fellow lost excel user. :) Unfortunately I can not get it to work so I need more information. I have a worksheet that is broken down into projects (areas in the worksheet). In each section I have to have one cell that tells when anything in the...

Hi My computer date/clock is DD-MM-YYYY. So I tried to enter the following. I understand all except 3rd and the 5th (the last) rows. Why Excel accepted yyyy-m-dd as a date and why accepted sept 14, 2019 as a date and changed to 14-sept-2019. but why did not change it to 14-09-2019 (why 09...

Hi, Basically if a cell is changed within a range (q_one) I want to put a date in another range(q_one_date) in the same row that the target cell was changed. The code I got referred to a set cell range rather than a named range. I have successfully changed it to work if any cell is changed in...

hi have this code :- Dim Changed As Range, Cell As Range Set Changed = Intersect(Target, Range("m2:k300")) If Not Changed Is Nothing Then For Each Cell In Changed If UCase(Cell.Value) = "YES" Then Rows(Cell.Row).Resize(, Cell.Column).Interior.ColorIndex = 35...

when any cell changes in row C it emails me what was changed and what it is now. Is it possible to see the names as well in row A in the email when any cell is changed in C.. So if C-3 was changed I see the information for A3 and C3 in my email. This is what im using any help be appreciated...

Hello. I'm unable to use a macro in a 64 bit version of excel that works in the 32 bit version of Excel. MS's documentation says the following. Can someone provide the known declarations that need to be changed or point me to documentation that say which declaration statements need to be...

Hi All I am not sure if this is possible, but I thought I would ask the question in case. I am using Excel for Mac 2016 and have created a Drop Down list. As we scroll down the list - the entry is highlighted in royal blue, but I have been asked if I can change this to our specific green...

Hi, Trying to get these two instances to run together but not sure how to simplify. Can provide any more information if needed. Private Sub Worksheet_Change(ByVal Target As Range) Dim Changed As Range Const YesCol As String = "L" ' Set Changed = Intersect(Target...