raven42_1978
New Member
- Joined
- Aug 21, 2013
- Messages
- 10
I have worked with Macro 4.0 for quite a while and feel that I'm pretty proficient with it, but now I'm trying to get into VBA to make my products better. There is a small project that I'm working on now to basically give me a little familiarity of VBA and having a couple problems. I have a workbook that has a list of names in column A; separated by sections. Using the Name Manager, I highlighted each section range and created a name for each. I created a UserForm that contains 2 combo boxes, one for the Section name and the other for the individuals names. List of names populates based on which section is selected. Once the individual is selected and a command button is pushed, their data populates in the text boxes. I'm also able to change the data in those text boxes and save it back into the spreadsheet.
Here is where my problem lies.
I have a button to insert a row in the spreadsheet below the individual that is selected in the UserForm.
Problem 1) There are three specific cells in the previous row that I want the data copied and pasted into the newly created row.
Problem 2) When I insert a new row in the middle of the range, the Name Manager updates the range of cells to include that new row and is also reflected in the individual name combobox. If I insert a row at the bottom of the range, the Name Manager is not updated to include that new row. Would like some VBA code that would update the Name Manager range of cells to include that new row and have it populate in the list of names when the Section is selected in the Userform
Any assistance would be greatly appreciated. There are other things that I want this Userform to do, but want to start with these problems first. Thanks.
Here is where my problem lies.
I have a button to insert a row in the spreadsheet below the individual that is selected in the UserForm.
Problem 1) There are three specific cells in the previous row that I want the data copied and pasted into the newly created row.
Problem 2) When I insert a new row in the middle of the range, the Name Manager updates the range of cells to include that new row and is also reflected in the individual name combobox. If I insert a row at the bottom of the range, the Name Manager is not updated to include that new row. Would like some VBA code that would update the Name Manager range of cells to include that new row and have it populate in the list of names when the Section is selected in the Userform
Any assistance would be greatly appreciated. There are other things that I want this Userform to do, but want to start with these problems first. Thanks.