Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro I think????
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro I think????
Try creating a new group box everytime and then adding option button in the
group box. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Eagle" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro I think????
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 "Satti Charvak" wrote: Try creating a new group box everytime and then adding option button in the group box. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "Eagle" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |