Because there have been repeated problems downloading the sample spreadsheets and other files from the usual server I'm posting all of the files in a single zip here. While I've got someone looking at what is causing the intermittent downloads fails, it seems worthwhile to have a backup of the download available here. I hope this helps save book readers some frustration in the future.

Attached Files

All Files978-1-118-99137-4ExcelVBA2e.zip (6.76 MB, 342 views)

__________________
Jim Minatel
Associate Publisher, WROX - A Wiley Brand
Did someone here help you? Click on their post!

Can someone show me to make menu on a userform1, please ?
If I move a cursor on "Button 2" then Submenu shows.

main menu
1. Button 1
2. Button 2 ->1. SubMenu Btn 1
------------------>2. SubMenu Btn 2
Thank you,
Lee

Thank you for buying the book.

I am not clear in understanding your question. It sounds like you want to show a menu when clicking or mousing over (per your reference to "move a cursor on") a button on a UserForm. Among the examples in the book are those that show the steps, with downloadable code, to create and code a CommandButton on a UserForm. The questions I have are what the menu interface looks like that you have in mind, maybe another UserForm is needed to show the menu if it is complex (you indicate a submenu of Button 2 for the submenu of Button 1 when Button 2 is clicked or moused over). Or if the menu is simpler, you might show a hidden ListBox or ComboBox with menu options on a single UserForm.

Your request may fall under the interest of a developer for your project, depending on what you are ultimately after. Or, if you can explain further what you are thinking, may I suggest that you repost the request under a new subject line rather than under this Sticky note. There are readers who visit this forum and may be more apt to see your request and help with it, if it is under a dedicated thread that would be quicker to see.

Thanks for that information. Understood

The message (written in 2015) states that "someone" is looking to determine why the code downloads for Excel VBA 24-Hour Trainer aren't working and that the attached zip file contains all the code. That's fine. But how come three years later it's still not fixed? The ZIP file did have everything I expected but the sequence of the extracted files is anything but self-evident. Yes, I know how to find what I want but I certainly expected this to be a more "elegant" process.