f2e4
08-01-2008, 01:45 AM
Hey guys,
This is what I am using so far:
Dim x as integer
staffdropdown = activesheet.combobox6.value
x = columns(3).find(staffdropdown, after:=cells(3,3)).row
With Cells(x,3)
if .value = staffdropdown then
.entirerow.delete
end if
end with
This will look down column 3 and find a value I have selected from a combobox.
It does work but only for the first entry.
Does anyone know how I can expand the code above to find all entries and then delete these rows as well.
Thanks a lot,
F
This is what I am using so far:
Dim x as integer
staffdropdown = activesheet.combobox6.value
x = columns(3).find(staffdropdown, after:=cells(3,3)).row
With Cells(x,3)
if .value = staffdropdown then
.entirerow.delete
end if
end with
This will look down column 3 and find a value I have selected from a combobox.
It does work but only for the first entry.
Does anyone know how I can expand the code above to find all entries and then delete these rows as well.
Thanks a lot,
F