I am making a chart that allows the user to input a list of features,
and for each of those features, any number of options are allowed. So,
the chart should begin two columns, and just one row with column
headings Features, and Options. The idea is that the user first inputs
the feature name on the left then adds options on the right. Under the
Features collumn is a button, "Add New Feature", which allows the user
to add an additional feature to the bottom of the chart. For each
feature there is a button, "Add Option", in the Options column that
inserts a row above the button to add another option. Each time the
"Add New Feature" button is clicked, it inserts two rows above the
"Add New Feature" button and also creates an "Add Option" button under
the Options column.

The problem I have is that I don't know to get excel to select the "Add
Option" button after it has been clicked so that the cell the button is
located over may be selected using, Selection.TopLeftCell.Select
After that cell is selected, the macro would add rows above the cell to
add more options. My only problem is selecting that button after being
clicked. Hope that clears it up, but i know its kind of confusing.


--
jpizzle
------------------------------------------------------------------------
jpizzle's Profile: http://www.excelforum.com/member.php...o&userid=23920
View this thread: http://www.excelforum.com/showthread...hreadid=376707