Macro I think????

[Eagle]

I am going to try to explain this as eloquently as I can.

I have a spreadsheet with a row of data. There are 6 columns per row. Each
row has a number, text field, VB Radio Button Group, text field, VB Radio
Button Group, and VB Radio Button Group.

I want to create a macro, I think, to link to a button that creates a new
row for data input.

I simply want to insert a new row for input with the same information as
existing rows. The only way I know to do that is to copy and paste, the
issue with that is that when I paste it has the data from the previous row, I
would prefer it be blank, and the radio buttons are grouped with the row
above and are not independent radio button groups.

Hope this all makes sense. Any assistance would be greatly appreciated... E

 

[Satti Charvak]

Try creating a new group box everytime and then adding option button in the
group box.

 

[Eagle]

Satti,

Thank you so much for your response, but I am unclear as to what you are
suggesting...

OK, if you have not figured it out yet I am not a programmer. I have found
answers to most of my questions here and have found this site to be
invaluable in getting my spreadsheet done the way I want it. I have enormous
praise for everyone who contributes answers here. I am not trying to be a
pest but I really would like to get the sheet to do what I want. I know it
is possible because I have seen others in the past with this functionality,
just wish I would have saved a copy of them.

I am probably not explaining this very well, so let me try again. In this
spreadsheet each of the three columns that have the radio buttons are
independent of each other. Meaning for example, in column "C" the options
are High, Medium and Low. The same options are in columns "E" and "F". I
have grouped each of the radio button sets and named each appropriately.

When I copy the row and paste it the buttons appear, however the column "C"
radio button set, for example, in the new row has the same name as the one
that was copied and therefore is tied to the row above it and therefore only
allows me to select one option from the two rows.

The idea here is that sometimes this spreadsheet will only have one row
while other times there is a need for 10 or more. I simply want to begin
with one and have a button to "Add a New Row".

Again, thanks in advance for any advice.... E