Clear cells when contents of combo box changes

[tedc]

How can I clear cells when I change the contents of a combo box.?
I now that I can attach a macro to it, but I’m not sure how to do this
Thanking you
Ted Cullen

 

[SIXTH SENSE]

hi
do you mean like this!


<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> ComboBox1_Change()
Range("a1").Value = ""
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>

 

[tedc]

Thanks mate. Works okay

Ted

 

[tedc]

Thanks mate. Works okay

Ted