Beatrice
Board Regular
- Joined
- Sep 17, 2019
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
I wish to create a simple drop-down box, option <YES> or <NO>
if the box is not filled, or selected as <NO>, then some of the specific cells content will be clear automatically.
My trial as below:
--
If Range("L66") <> "Yes" Then
Range("R61,R62,Q64,R64,Q65,R65,Q66,R66").ClearContents
End If
End Sub
--
but it failed, what is the reason behind and how to fix it?
Thanks in advance for your help.
if the box is not filled, or selected as <NO>, then some of the specific cells content will be clear automatically.
My trial as below:
--
If Range("L66") <> "Yes" Then
Range("R61,R62,Q64,R64,Q65,R65,Q66,R66").ClearContents
End If
End Sub
--
but it failed, what is the reason behind and how to fix it?
Thanks in advance for your help.