Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
I have attached below and the result in Cell B5=Enter Something
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Address = "$B$5" Then If Len(Target.Value) = 0 Then Target.Value = "Enter Something" End If End Sub Question: In Cell B6 can I use some kind of formula resulting in "Enter New Code" along with the same formula above. Meaning: Same worksheet: B5=Enter Something B6=Enter New Code Additional: Example of Result Same worksheet: B5=Enter Something B6=Enter New Code C1 to C2=Enter Old Code E1=Help Me. Thanks a bundle. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
Format cells with a formula (7 conditions). | Excel Discussion (Misc queries) | |||
Return Numerical Label for LAST value Subtracted to reach Sum Target Value | Excel Worksheet Functions | |||
more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) |