find
 

Zaahir,

Worksheets("SheetName").Cells.Find(UserForm1.Combo Box1.Text).Clear

Or

Worksheets("SheetName").Cells.Find(UserForm1.Combo Box1.Text).ClearContents

Or

Worksheets("SheetName").Cells.Find(UserForm1.Combo Box1.Text).Resize(1,10).Delete

HTH,
Bernie
MS Excel MVP


"Zaahir" wrote in message
...
Hi

my combobbox is populated with data off a sheet. i'v tried recording a macro
to capture the code for using Find.....

i want to use this so that info can be deleted off the sheet by selecting
from the combobox and clicking cmddeleteEntry......
macro recording doesn't capture the Find execution......
how can i achieve my goal?
Please Help!!!
regards!!!!!