Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dialog Based Upon Cell Properties
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dialog Based Upon Cell Properties
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. "Edd" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Properties dialog box opens instead of a workbook | Excel Discussion (Misc queries) | |||
RowSource in Properties Dialog continued...... | Excel Programming | |||
VBA: how to... cell properties has to change based on a condition | Excel Programming | |||
Form Controls; setting properties based on cell values | Excel Programming | |||
Cell properties dialog | Excel Programming |