list box DELETION during a macro

[Chris M]

Hi all...
I have a macro which inserts a new "row" with a list box at the beginning of
the row. The code is fine

I need to have the user be able to DELETE "extra" rows if needed. The row
delete is no problem of course, but I'm struggling with getting the list box
at the beginning of the row deleted. Selecting the list box during the macro
and deleting it gives me specific code for the list box NUMBER (Like "Listbox
199"). I need the macro to delete whatever listbox happens to be on the row
(not specific to a number).

I suspect there's a way to do this...
Is there a way to select the cells/row as well as a generic list box at the
same time for deleting?

THANKS for any help! Excel 2003

Chris
--
Chris M

[Tom Ogilvy]

You would have to loop through the shapes collection and check the
topleftcell and lowerRightcell properties to determine which one to delete.

--
Regards,
Tom Ogilvy


"Chris M" wrote:

> Hi all...
> I have a macro which inserts a new "row" with a list box at the beginning of
> the row. The code is fine
>
> I need to have the user be able to DELETE "extra" rows if needed. The row
> delete is no problem of course, but I'm struggling with getting the list box
> at the beginning of the row deleted. Selecting the list box during the macro
> and deleting it gives me specific code for the list box NUMBER (Like "Listbox
> 199"). I need the macro to delete whatever listbox happens to be on the row
> (not specific to a number).
>
> I suspect there's a way to do this...
> Is there a way to select the cells/row as well as a generic list box at the
> same time for deleting?
>
> THANKS for any help! Excel 2003
>
> Chris
> --
> Chris M