What book would be recommended to learn about UserForm and Module in 2023?

[cyrilbrd]

Good day to all,
Any recommendation for VBA noob pertaining to UserForm creation?
Objective would be to get a hands-on type of approach with exercises aiming at developing work habits in VBA.
Thanks in advance for any/all input.

 

[Joe4]

Most books that get deep into VBA should have sections on UserForms. A quick search of the MrExcel store found this book: Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365). In the description, it includes:

• Build sophisticated UserForm custom dialogs to collect data from other Excel users

That being said, as someone who uses both Excel and Access, for anything that requires a lot of forms, I much rather prefer Access forms to Excel forums. Access forms are so much easier to create (mostly drag and drop), and you can easily "bind" the fields to the data sources behind them (where Excel requires you to explicitly write VBA code to link each field).

Of course, that all depends on whether Access is available to you, and how comfortable you are using it (its learning curve is a bit steeper than Excel's). But all things equal, I always prefer Access forms over Excel forms.

 

[cyrilbrd]

Most books that get deep into VBA should have sections on UserForms. A quick search of the MrExcel store found this book: Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365). In the description, it includes:


That being said, as someone who uses both Excel and Access, for anything that requires a lot of forms, I much rather prefer Access forms to Excel forums. Access forms are so much easier to create (mostly drag and drop), and you can easily "bind" the fields to the data sources behind them (where Excel requires you to explicitly write VBA code to link each field).

Of course, that all depends on whether Access is available to you, and how comfortable you are using it (its learning curve is a bit steeper than Excel's). But all things equal, I always prefer Access forms over Excel forms.

Yup I saw that book, tried to buy it 3 days ago and got my credit card details rejected by informit.
Will try to get on Amazon but deal is not as sweet.
Google search gave me limited satisfaction with in some cases less than 2 pages covering the subject, but maybe I imagine it to be more complex than actual. Access recommendation is noted. Will look into it.