hi
ive added a button in attached excel... When click on the commandButton1,cells b2, b3 and b5 should be empty. keeping the drop-down list values and colors border.
any idea?
hi
ive added a button in attached excel... When click on the commandButton1,cells b2, b3 and b5 should be empty. keeping the drop-down list values and colors border.
any idea?
Formula in C2Formula:
=IFERROR(VLOOKUP(B2,'drop-down'!$A$2:$B$8,2,FALSE),"")
In C3Formula:
=IFERROR(VLOOKUP(B3,'drop-down'!D2:E4,2,FALSE),"")
In B5Formula:
=IF(B2="","",IF(OR(B2="Australia",B2="Austria"),"NO ACTION",IF(J5<50,"NO ACTION",IF(J5>=100,"MAIL","CALL"))))
And for the button use![]()
Private Sub CommandButton1_Click() Range("b2:B3").Value = "" End Sub
when click on the btn, the cell formatting color and cell borders are also being removed...
how can i keep the cell color and borders. any formula to be added pls?
Have you changed your code to the code I supplied?
yes i did used same.
But when click the color and borders are removed.
Not if you've changed the code
yes its ok. thanks a lot![]()
You're welcome & thanks for the feedback
Last edited by Akika; 06-09-2019 at 03:30 AM. Reason: added excel
This is a totally different question & as such you need to start a new thread.
ok noted wl create a new thread thxs a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks