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:
Thank you in advance!Please Login or Register to view this content.
Bookmarks