Hi there,
I have a spreadsheet that with 7 columns and mulitple rows. These rows are divided into 4 sections.
I have created a UserForm where data can be inputted and inserted into the spreadsheet. However, I am unable to choose with of the 4 sections in the spreadsheet the data is inputted into.
My idea is that the UserForm will contain a ComboBox with 4 dropdown options, each representing 1 of the 4 sections. Depending on which option is selected, a new row will be created with the data of the UserForm in the appropriate section. Is this possible? If so, what would the correct code be? I imagine that the "Submit" command button would have a code that reacts to what option in the ComboBox is selected.
Thanks,
Henry
Bookmarks