Help a newbie!

[southernsquid]

I want to be able to double click in a cell and it places a X in the cell. I want to also have that X have a value=1. Better yet I would like to be able to double click and get a color and have the color have a value.

I have a macro for the double click for color but how do I add in a value? Is it even possible?

Here is the macro I have and I should mention, this is the 1st macro I've ever delt with. Please explain exactly how to add any new macros you can provide. Thanks

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)
 
   If Target.Interior.ColorIndex = xlNone Then
 
     Target.Interior.ColorIndex = 4
 
   ElseIf Target.Interior.ColorIndex = 4 Then
 
     Target.Interior.ColorIndex = xlNone
 
   End If
 
   Cancel = True
 
End Sub

 

[GlennUK]

You are not making sense. Can you explain what you mean by:

"it places a X in the cell. I want to also have that X have a value=1"

and

"get a color and have the color have a value"
?

Do you mean that you'd like to count how many X's there are afterwards? ( use the COUNTIF function ).

Or that you'd like to count by colour? Don't try and go this route ... fill with X or 1, and if you want the cells coloured use Conditional Formatting to colour them depending on their contents.