excel16, Reset cells to empty but keeping dropdown values when button is clicked

[Akika]

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?

[Fluff13]

Formula in C2

Please Login or Register  to view this content.

In C3

Please Login or Register  to view this content.

In B5

Please Login or Register  to view this content.

And for the button use

Please Login or Register  to view this content.

[Akika]

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?

[Fluff13]

Have you changed your code to the code I supplied?

[Akika]

yes i did used same.
But when click the color and borders are removed.

[Fluff13]

Not if you've changed the code

[Akika]

yes its ok. thanks a lot

[Fluff13]

You're welcome & thanks for the feedback

[Akika]

You're welcome & thanks for the feedback

hi for the dropdown ive used a list of data validation.
how can i make it autocomplete dropdown ?

Created 2 combo box and added some code to it.. but dont seems it working. can u pls chk & help.

[Fluff13]

This is a totally different question & as such you need to start a new thread.

[Akika]

ok noted wl create a new thread thxs a lot.