Listing Precedents/Dependents in a list box

**learning2** · 07-07-2012, 11:05 AM

Hi,

Does anyone know how to list in text format either the precedents or dependents of a cell including external ones?

When I write:

Please Login or Register  to view this content.

I get all the dependents listed and deliminated by a comma. Iam trying to figure out how to list each one individually in a msgbox or something, using a for next or some loop.

help, please

**nilem** · 07-07-2012, 12:06 PM

maybe so

Please Login or Register  to view this content.

**learning2** · 07-07-2012, 12:14 PM

Originally Posted by nilem

maybe so

Please Login or Register  to view this content.

Thanks Nilem,

That parsed it out, but, is there a way for it to list dependents/precedents in a different worksheet?

**nilem** · 07-07-2012, 02:59 PM

From VBA help: "The Direct Dependents property only works on the active sheet and can not trace remote references."

**learning2** · 07-07-2012, 05:21 PM

Thanks, now to figure out how to get external references

Originally Posted by nilem

From VBA help: "The Direct Dependents property only works on the active sheet and can not trace remote references."

Listing Precedents/Dependents in a list box

LinkBack

Thread Tools

Rate This Thread

Display

Listing Precedents/Dependents in a list box

Re: Listing Precedents/Dependents in a list box

Re: Listing Precedents/Dependents in a list box

Re: Listing Precedents/Dependents in a list box

Re: Listing Precedents/Dependents in a list box

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions