Dialog Based Upon Cell Properties

[Guest]

I need to fill some cells using results from a custom dialog. I need to use
a different dialog with some cells and need a way to differentiate which will
be selected based upon the cell. This needs to be a bit dynamic so that it
can be changed if the format of the form is changed for some reason to
accomodate the users need. Can this be done based upon a custom property of
the cell or cells of interest?

Hope I was clear.

 

[Guest]

Clear enough to give you the basic answer: YES this can be done.

Without more info, a more detailed answer is impossible to give. Look at
the _SelectionChange() event for worksheets to use to determine what cell(s)
have been selected, which can be fine tuned to tell you whether it's a cell
of 'interest' or not, and then you can examine the properties of the cell to
determine what further action to take. Once you get inside of the
_SelectionChange() event you can use the Application.Intersect procedure to
determine which cell(s) have been selected.

As for making this all dynamic to permit easy revision of the layout of the
worksheet, look into using Named Ranges to identify your cell(s) of interest.