Delting contents of cell, if another equal a certain value...

S

soltek

I have a drop-down list with various descriptions of an order, and i
thie description equals "CANCELLED", i would like another cell to b
cleared or deleted of contents. Can this be done without macro or VB?
Or can it just be done period? Thanks in advance
 
G

Guest

Guess K's solution showed you eh?? ...
-----Original Message-----
Hi
to clear a different cell without macros is not possible

--
Regards
Frank Kabel
Frankfurt, Germany

without macro or
VB?

.
Click to expand...
 
F

Frank Kabel

:)
One can argue if this deletes a different cell. But as long as the OP
is happy with this solution :)
 
K

kkknie

No need to argue here. It definately doesn't delete anything, but
figured that making it not show up would be OK. Hopefully it is jus
for display/printing purposes...
 
G

Gord Dibben

anonymous

The cell is not "cleared" or "deleted of contents", just looks blank, so no
one got "showed" anything.

If you're going to make smartass comments about others, at least have the
balls to use a name.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Drop down box w/contents of different worksheet? is this possible 1
display contents of cell if adjacent cell equals 1
Selecting cells equals to a value 3
Copy corresponding cell in Column B if cell in A contains certain text? 1
See if cell value appears within a value range given by another cell. 9
Need cell to equal another cell if certain criteria is met? 2

Top