What can I say, You saved me a lot of work and searching, honestly, I couldn't find any simpler way to do it, at first I was thinking of Sorting all the spreadsheet and then populate the combocox, but this is waaaaay better way way better then messing around with the data, thank you man
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
I used the code for text and it worked as intended, except the combo box held both the sorted text as well as the original text. How do I delete the original unsorted text so both lists don't show? Thank you in advance. I truly enjoy and have learn a tremendous amount from your videos.
thanks Dan. Great video as always! I'm surprised that there isn't a built-in property of the combo box that would do this automatically. BTW is there a function similar to "to upper" that you could use within the code, which would force everything to alphabetize whether or not upper or lower case was used?
Thanks Dan. Your videos always come right on time it seems like. I created a userform to display classes taken by an individual. I created a cmbLast for the last name that is loading from all last names in sheet (dynamic). cmbFirstName gets its information from a change event in cmbLast, which lists only First names belonging to the Last I select. cmbBadge gets it information from a change event in cmbFirst, which again lists only badge (employee nbrs) from the First name. Finally I have the lbInfo to capture Class Names and Dates taken. Currently this works fine, but having issue with adding a third column. I want to capture the row number for each Class Name and Date taken so the user has can go back to the sheet and view or modify specific row. Using MATCH to try and get this. Still working on it... I will figure it out. Thanks again.
What can I say, You saved me a lot of work and searching, honestly, I couldn't find any simpler way to do it, at first I was thinking of Sorting all the spreadsheet and then populate the combocox, but this is waaaaay better way way better then messing around with the data, thank you man
works perfectly,
just change the signal > or < to change the sort
thanks
Worked perfectly! Thank you so much.
Awesome! So glad it helped!!
Great Danny, exactly what I was looking for as a following up to one of your previous videos. Thank you!!!!
So glad it helped! Dan
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
I used the code for text and it worked as intended, except the combo box held both the sorted text as well as the original text. How do I delete the original unsorted text so both lists don't show? Thank you in advance. I truly enjoy and have learn a tremendous amount from your videos.
that was good! thanks!!
Mind blowing
sartaj alam Thanks, sartaj!
Thanks bro It was very helpfull
Absolutely! You are very welcome! Dan
thanks Dan. Great video as always!
I'm surprised that there isn't a built-in property of the combo box that would do this automatically.
BTW is there a function similar to "to upper" that you could use within the code, which would force everything to alphabetize whether or not upper or lower case was used?
You mean to sort not only by alphabet but also by capitalization as well? Sounds like it would have to be custom built!
On dataset over 1000 rows it will take a lot of time
Thanks Dan. Your videos always come right on time it seems like. I created a userform to display classes taken by an individual. I created a cmbLast for the last name that is loading from all last names in sheet (dynamic). cmbFirstName gets its information from a change event in cmbLast, which lists only First names belonging to the Last I select. cmbBadge gets it information from a change event in cmbFirst, which again lists only badge (employee nbrs) from the First name. Finally I have the lbInfo to capture Class Names and Dates taken. Currently this works fine, but having issue with adding a third column. I want to capture the row number for each Class Name and Date taken so the user has can go back to the sheet and view or modify specific row. Using MATCH to try and get this. Still working on it... I will figure it out. Thanks again.
can you send me a dummy wb? Sounds like a video I should have made awhile ago. Got some ideas for you.
smart code, bad video