Change Cell Color On Click And Reverse Macro

May 3, 2007

I am making a checklist for a Pda program. I need the active cell to highlight green and put an x in it for a specified range. This I have

The next part I cannot figure out -
after the cell have been highlighted once, and properly colored with an x, how can I get it to delete the fill and clear the x on the next click.

Dim x As Long
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
' Set the highlighted cell to a color.
If Not Intersect(Target, Range("d28:d34")) Is Nothing Then
Target.Interior.ColorIndex = 4 ' green = true
'Set the highlighted cell to contain a text character
If Not Intersect(Target, Range("d28:d34")) Is Nothing Then
ActiveCell = "x"
End If
End If
End Sub

View 5 Replies


ADVERTISEMENT

Click On Cell Change Color

Sep 5, 2009

In Excel 2007 I been scanning in the forum for example code. If a cell is clicked on Then highlight the that row from cells A to K. If it is clicked again change it back to no color.

View 9 Replies View Related

Change Cell Value & Color On Click

Aug 12, 2008

I want to set up a column so that by clicking a cell once it changes value AND color.

For eg a clicked cell changes to green with a value of 1 point, click again it changes orange with a value of 2 points, click again it changes to red with value of 3 point, then finally click again goes back to no fill with nil value.

This would very very useful for marking my candidates results and categorising them by their level of understanding of a question.

View 6 Replies View Related

Change Cell Color With Single Click

Mar 28, 2013

How i can change the coulor of a cell when somebody clicks the cell using VBA? I need the cells to turn green.

View 9 Replies View Related

Locked Cells :: Change The Cell Color On The Click Of A Command Button

Mar 1, 2010

i want the user to be able to change the cell color on the click of a command button. the worksheet is protected. when the user click the command button the active cell changes to red and offsets by 1. then the work sheet is locked again.

The two problems I am having is 1. I want the range to begin from row 10, column k to column FD. all cells down

the second problem is the current code allows me to edit locked cell columns A to J ...

View 9 Replies View Related

Change Color Of A Shape With Click

Oct 8, 2009

what i am trying to do is toggle the color of a shape between red and green. what i have currently (courtesy of a search on this site) is this macro:

View 9 Replies View Related

Change Button Color Upon Click

Mar 30, 2009

I was wondering if it is possible to change the color of a command button after it's been clicked?

This is to allow the user to identify which buttons have already been clicked.

View 9 Replies View Related

Click On Color Button And After Button Click It Will Color Entire Row Of Cell?

Jan 23, 2014

what code I can put behind a button so that once I click on that button,

What ever cell i click on, the whole row of that cell will be colored a certain color.

Is this where i would used a target approach?

View 6 Replies View Related

Change Color Of Offset Cell With Macro?

Jul 9, 2014

I am trying to color a cell with a macro. I am using

ActiveCell.Offset(a,b).Value= a number then a want to change the color of the cell to yellow. When I tried to code this, my Active cell's color is changed, but not the offset cell.

How do I change the color in an "offset cell".

View 5 Replies View Related

Reverse Before Double Click

Sep 29, 2006

I am trying to create code so that when a cell in Column C (for example C1) is double clicked, it makes the font bold, italicized, blue and inserts a row below the double clicked cell. I am also trying to make it so that if the cell is double clicked again, it removes the bold, italics, blue and deletes the row that was previously inserted.

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Excel.Range, Cancel As Boolean)
If Target.Font.Bold Then
ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Select
Selection.Insert Shift:=xlDown
ActiveCell.Select
Cancel = True
If Not Target.Font.Bold Then
ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Select
Selection.Delete Shift:=xlUp
ActiveCell.Select
Cancel = True
End If
End If
End Sub

View 3 Replies View Related

Formula Or Macro To Change Font Color For Each Cell In Range

Aug 12, 2009

I have a spreadsheet that contains the 5 digit numbers in the rows and the columns respecstively. I'd like a formular or macro to change font color for each cell. If the combined value of the 5 rows are greater or less than the combined range 87030 and 87200, the 5 cells will be changed to Red. If:.........

View 4 Replies View Related

Macro Button To Change Background Color Of Specific Cell

Sep 17, 2008

My boss wants a spreadsheet that has multiple buttons on it that will change the background color of a specific cell to four different colors. Example:

Text written in Cell B3, Button in Cell A3 that will change the Background color of Cell B3 to either Green, Yellow, Red or Blue.

There will be a lot of buttons on this worksheet following the same format as above. I don't want to change the value of what is in the cell, just the background color.

View 7 Replies View Related

VBA Macro To Auto Change Cell Color On Protected Sheet Based On Input

Apr 13, 2009

I have a macro code for conditional formatting. The first 2 lines of the macro are


Private Sub Worksheet_Change(ByVal Target As Range) ....

View 9 Replies View Related

Macro To Right Click A Cell And Select Item From Right Click Menu?

Feb 7, 2014

I wonder if it is possible to make a macro that right clicks a cell and then chooses a option from the list?

View 11 Replies View Related

Click Cells To Take Attendance By Cell Color

Feb 18, 2008

I would like for a vba programmer to tell me if the following program can be written before I attempt to code it. When I open Excel I want to see cells containing names in a square array with red backgrounds. As I click on each cell I want the cell to turn green and I want an alphabetized column of the names to have a 1 recorded(after I click) indicating that the person is present. If a person's name is red then I need a 0 recorded. If possible, I would like to be able move over one column each day that I take attendance by clicking on a cell in a row above the column of names. I am a math professor and I write computer code most every day but I have only written some small routines in vba that did not involve events.

View 3 Replies View Related

Auto Calculate Color Function On Cell Color Change

Feb 15, 2010

I would like to be able to change the color of a cell in V4:AB31 and have the formula in AM10:AM13 automatically calculate the new result. As it is now the user has to press Ctrl ALT f9 for the formula to recalculate.

View 7 Replies View Related

Change Font Color Based On Adjacent Cell Color

Apr 18, 2008

I have two columns. The first one (A) contains cells that have different Fill colors. The second column (B) contains text adjacent to the colored cells. I am trying to change the color of the text in the second column (B) to the corresponding color in the adjacent cell in the first column (A). I don't think conditional formating works well in this situation. I believe the solution would be some sort of macro.

View 3 Replies View Related

Change Font Color If Cell Color Become Yellow (6)

Jul 9, 2009

I have font color white in blank cells in column E and I (from row 5 to row 245) so the visitors will not see the text. If any of these cells become yellow (color code is 6), the font color will become black so visitors can see the text alot far better than white. I've tried this code myself after this post but nothing happen

View 4 Replies View Related

Change Text Color Based On Cell Color

Oct 17, 2006

I have various row cells in column (F) filled with the color Green. And corresponding text in Column G. How can I change the text of that particular row to white.

i.e.: if any cell in column F is Green, change the text color of that row in Column G to white?

View 5 Replies View Related

Reverse Data In A Cell / Reverse Cell Contents

Dec 18, 2009

I am trying to write a formula to reverse data in a cell. Basically I am converting a number to hex then I want to take that hex string and reverse it. So it would be something like this my original number is 400001001 my hex number would be 17D787E9 because I am only allowing it to show 8 characters. I want to reverse the 17D787E9 to read 9E787D71.

My question is: How can I reverse that cell? I have searched google and this forum and can't seem to figure it out. I am sure I could do it in VB but I don't know any VB code.

View 5 Replies View Related

Change VLookup Value With A Click On Cell?

Jun 5, 2014

I have a search feature that will display several results based on the criteria of the search. I also have a Vlookup set so when the topmost name appears in A5 cell the, vlookup shows info for that person across several columns. However if the search shows several people with the similar names then the person I want may not be in the topmost box (A5). Is there any way that I can click on the cell with the correct persons name (may appear in A10) that will change the value in the vlookup command and show the details of the person I can't copy the vlookup down for ten rows as there is other info there. I have room for one row for the vlookup command to fill.

View 2 Replies View Related

Change The Cell Color On Drop Down Change

Jun 3, 2008

I have a drop down sub pasted to worksheet:

Private Sub ComboBox1_Change()
ComboBox1.List = Array(100, 200, 300, 400)
If Range("I11").Value < Range("N11").Value Then
If Sheets("Profile").Range("K18").Value < ComboBox1.Value Then
Range("I11").Interior.ColorIndex = 2
Else
Range("I11").Interior.ColorIndex = 3
End If
End If

End Sub

I want it to change the cell color on drop down change. How can I modify things to have the change in drop down selection?

View 9 Replies View Related

Macro To Change Tab Color

Feb 2, 2009

I keep recording this macro, but the problem I run into is that the active sheet is always the specific name of the sheet. I need a general name so that the macro will work on any given sheet. On the sheet I am viewing, I simply want to change the tab color to black using a macro.

View 2 Replies View Related

Inconvenience With Color Change In Macro

Apr 18, 2009

I use the following code to change several colors in my worksheet.

View 9 Replies View Related

Macro To Change Font Color

Jan 25, 2007

macro that will change the cell color based on text? I have a list of titles in column B. Everytime the word 'Car' is found in this column, I would like to change the font color in columns C-G to the color white within the same row.

View 9 Replies View Related

Macro To Change Color Of Cells Based On Sum

Jul 26, 2014

When the sum of B7-D7 is less than cell (I7) I would like to change the shade of B7-D7 to orange to indicate that larger values need to be entered to equal the value of cell I7. And when the sum of these three cells does equal I7 their color should change to green. I recorded two macros to change the colors and I've run them to verify they work. But I've got something off in my simple macro below.

[Code] .....

View 4 Replies View Related

Macro To Change Background Color And Text Of Certain Cells On Mouseclick

Mar 15, 2013

creating a macro. I would like the background color of certain cells under column A (cells 12:25, 27:32, 34:38, 40:45, 47:51, 53:61, 63:70, 72:79, 81:88, 90:92) to change to the color green and display the text "Complete" on mouseclick.

Before the cell is clicked, it would be the color red, with no text. (I'm not sure if you need to know that).

Next, I would need a macro that resets everything back to red. I hope this macro could be assigned to a form button.

View 1 Replies View Related

Color Change In A Cell

Nov 24, 2009

What formula do i use if i want the text in cell A1 to change to red if any entry is made in cell B1.

View 2 Replies View Related

Change The Color Of Cell

Dec 14, 2009

I am having some color problems. From A2:AB2000 I have different fill colors for cells all over the place. The only color I need is the color purple which I believe is the color “39”.

So basically all cells except the cells with the color purple change to white from A2:AB2000. I would like to add this code to the macro I have already created.

View 2 Replies View Related

Change Row Color On Cell Value?

Nov 22, 2012

I'm trying to put together a script which changes the color of the row in columns A:AE if any cell in the Range B7:B400 has the value of 'No'. If it has the value of 'Yes' I would like it to Exit Sub.

I've put together the code below to try an create this function, but I'm running into a few problems.

Code:
If Intersect(Target, Range("B7:B400")) Is Nothing Then Exit Sub
If Selection.Cells.Count > 1 Then Exit Sub
If Target "No" Then[code]....

When the value of any cell in Range B7:B400 is 'Yes' the row changes to grey, if I enter 'No' it removes all cell shading from the row, and I'm not very clear on what changes I need to make.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved