Userform; Output displays in varying range depending on Combobox selection

Hello all!

Looking for some help from anyone who has experience with userforms and getting the data allocated to its proper place.

My code is currently working with displaying the inputs from my userform into the proper columns, and is correctly finding the last populated row...but I am trying to find a solution for when a specific value is selected off of my first combo-box, a dropdown menu, the data is displayed into the last populated row of a specified range.

ex. when combobox1 = a, the data from the userform is added into the range A1:AA50
when combobox1 = b, the data is added into the range A51:AA100
when combobox1 = c, the data is added into the range A101:AA150
etc...

I have product categories which have respective individual products and information which need to be added underneath of the proper category, and so on....

My current code is as follows:

Please Login or Register  to view this content.

Thank you in advance!

see big yellow banner - for positive response upload your workbook - far easier for us to then give suitable advice.
also moderators will require you to place code between code tags - as this is your first post they may be kind enough to do it on this occasion for you.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you today.)

I am trying to read between the lines and picture your data storage sheet, is your data in two blocks (one below the other - i.e. two separate categories).
If so this is bad structure for data handling - put everything in one table with an extra column at the start containing the category name.
This may seem counter-intuitive however as your data grows you will see the reason (i.e.you do not have to restructure your table and start re-coding limits).
Far easier to illustrate when you have uploaded your workbook.