URGENT HELP!!

[silverskye787]

I have some problem with this set of codings

can someone help me?

If A17 = 1 Then
    Range("A19:B22").ClearContents
ElseIf A17 = 2 Then
    Range("A20:B22").ClearContents
Else
End If

cell Range A19:B22 cannot be cleared if A17 has a number 1

 

[jindon]

What is A17, your variable?
Show me your "Dim" statement, or maybe just ....... Range("a17"),, hahaha LOL

 

[silverskye787]

A17 is just drop down box with number of 1-10

Range A18: B22 are a set of yellow boxes that allows user to enter information in it.

 

[jindon]

What is "Box"?

If you are "Urgent" like this response, Don't ever put such word in the title.

So, you haven't even tried my suggestion, have you?

 

[silverskye787]

hmm.. i have tried.. but now i need to know how to delete those cells in that doesnt have yellow box like this example

I want to delete A19 automatically

sorry ya..

 

[jindon]

Post your altered code.

 

[silverskye787]

I used conditional formatting.. i didnt write any codes.

i just need a guide on how to write an if else statement for this to clear the content

 

[jindon]

Excuse me?

You just have posted your code in your first post and then I suggested something.

You are always something like this and I should quit responding to your thread...

 

[silverskye787]

sorry sorry...

i really need help.. i really very sorry that i'm now very confused too.. got so many problems to solved.

the codes in the first post is not the actual one.

i type that codes is for better understanding. There are something wrong with it because i'm not sure with the codes. that's why i'm asking for this favour..

i didnt have the full codes because i don't know how to start typing the if else statement

 

[ADAMC]

SilversKYE....

What EXACTLY do you wish to do?