Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello again all of you VERY helpful people! :)
I have a macro to add an "X" to certain cells using the Worksheet_Intersect VBA function. The problem is that I would like to see only 1 "X" at a time, but the following macro will allow for both cells (C11 and I11) to have an "X" at the same time. ----- Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Not Intersect(Target, Range("C11,I11")) Is Nothing Then If Target = vbNullString Then Target = "X" Else Target = vbNullString End If End If End Sub ----- Can I add something to this where if C11 already has an "X" and they click on either C11 or I11, it will remove the "X" from C11 and put one in I11? Thank you! Ronny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to remove text in specific place | Excel Worksheet Functions | |||
Remove data from certain rows and place in new row or spreadsheet | Excel Worksheet Functions | |||
Intersect Operator vs Explicit Cell References and the Dependency | Excel Programming | |||
how to get the intersect cell data out using vba or function | Excel Worksheet Functions | |||
Is there a "Non-Intersect" VBA method to remove a sub-range from a range? | Excel Programming |