Excel UserForm Course 2 - Menus, Lists, ComboBox, OptionButtons, CheckBox & More

[@TeachExcel]

UserForm Free Couse Playlist: th-cam.com/video/QQNQObpAjL8/w-d-xo.html

[@tha2irtalib343]

Thanks for sharing this article , it's helpful.

[@TeachExcel]

You're very welcome! I'm glad you think so :))

[@lisacapamagian4429]

This was brilliant thank you!

[@wayneedmondson1065]

Nice tutorial! Thanks!!

[@TeachExcel]

Thanks Wayne! :)

[@peteronderwater4269]

Thanks! 👍

[@TeachExcel]

You're very welcome Peter!

[@peteronderwater4269]

a curious question about the course: can you also see the entered records in the entry screen in order to possibly change them, delete them, etc? 😊

[@dragosmilea9691]

are you the guy with the cookies ? Your voices are so alike :)

[@ahmadhusny7849]

Thanks so much, can you send the link for excel user form course 1

[@TeachExcel]

Yes sir, here you go: th-cam.com/video/QQNQObpAjL8/w-d-xo.html

[@darrylmorgan]

Great Follow-Up Tutorial...Thank You Sir :)

[@TeachExcel]

Thank you so much Darryl! I'm glad you like it :)

[@Michałbłaszczyk-h3c]

very helpful material, but for some reason when I save new data or save an edit from the user form level, it takes about a minute, when I save it directly from the VBA code, it takes a second. Could you please help me?

[@lyl8116]

When I do the listbox, what if the RowSource has duplicate value? How to code to make sure the listbox only contain unique value? Thank you!

[@Isfandiyor-k2e]

watched

[@simplydoing9596]

i think you don't know power of VBA
Public Dim whichPet as string
(sorry for my bad vba code)
Option Button Dog .Click event may be set to whichPet= "Dog"
Option Button Cat, Click event may be set to whichPet= "Cat"
Just like we do in javascripts ? or HTML ? HIDDEN LIVE CODING working
in background setting vars to value
So, now when we want to take values of Cat/ Dog option , in Submit_click sub
then just type a simple code
inputRange... Value = whichPet 'Public variable which contains click equivalents