|
|
|
|
#1
08-28-2012, 06:45 PM
|
||||
|
||||
Kooooollll. Now that we've gotten over this hurdle, how can I get the cells to turn white again when they're cleared. Can I use the string that you last sent me; if so where in the code, if not, what can be done? Never mind, I thought that I'd be able to select several cells and clear them at once. But 1 at a time will work. Catalin, much thanks for your attention and input. I know that it's not a lot, but I really do appreciate all you've done...
Last edited by fedcco; 08-28-2012 at 07:17 PM. Reason: Reiterate 
|
|
#2
08-28-2012, 10:43 PM
|
|||
|
|||
|
It is already in the code, just read it...Of course, works for 1 cell, as this line says:
If Target.Count > 1 Then Exit Sub If the target cell is cleared, the line of code below, which is already in the code above, will reset the cell color settings. If Len(Target) = 0 Then Target.Interior.ColorIndex = 2: Target.Font.ColorIndex = 1
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro ? - Checkbox in Word + drop down selection help
|
dice1976 | Word | 4 | 07-24-2012 11:18 AM |
| Change cell color everytime a value is selected in dropdown list | angelica_gloria | Excel | 4 | 01-27-2012 06:47 PM |
| Made a mistake with a macro change | lance_kidd | Word | 0 | 02-09-2011 06:36 PM |
| Ho to perform multi selection in drop down lists? | nashville | Word | 0 | 09-29-2010 07:10 AM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Windows 7 32bit 
Office 2007
Hybrid Mode