Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > BOOK: Excel VBA 24-Hour Trainer 2nd edition
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Excel VBA 24-Hour Trainer 2nd edition
This is the forum to discuss the Wrox book Excel VBA 24-Hour Trainer 2nd Edition by Tom Urtis; ISBN: 978-1-118-99137-4
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel VBA 24-Hour Trainer 2nd edition section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old October 15th, 2015, 01:49 PM
jminatel's Avatar
Wrox Staff
Points: 17,437, Level: 57
Points: 17,437, Level: 57 Points: 17,437, Level: 57 Points: 17,437, Level: 57
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2003
Location: Indianapolis, IN, USA.
Posts: 1,933
Thanks: 60
Thanked 128 Times in 97 Posts
Default Full Code for 2nd Edition Here

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
File Type: zip All Files978-1-118-99137-4ExcelVBA2e.zip (6.76 MB, 242 views)
__________________
Jim Minatel
Associate Publisher, WROX - A Wiley Brand
Blog: http://p2p.wrox.com/content/blogs/jminatel
Wrox on Twitter: http://twitter.com/wrox
Did someone here help you? Click on their post!
Reply With Quote
The Following User Says Thank You to jminatel For This Useful Post:
  #2 (permalink)  
Old October 31st, 2015, 06:50 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2015
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default programming menu, submenu in vba excel 2007

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

Last edited by SLee; October 31st, 2015 at 06:54 AM.
Reply With Quote
  #3 (permalink)  
Old November 4th, 2015, 02:30 PM
Wrox Author
Points: 213, Level: 4
Points: 213, Level: 4 Points: 213, Level: 4 Points: 213, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2015
Location: San Francisco, California, USA
Posts: 34
Thanks: 0
Thanked 5 Times in 5 Posts
Default

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.

Quote:
Originally Posted by SLee View 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
Reply With Quote
  #4 (permalink)  
Old November 24th, 2017, 10:11 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 50%
Activity: 50% Activity: 50% Activity: 50%
 
Join Date: Nov 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Thanks!

Thanks for that information. Understood
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Code For 2nd edition debrucato BOOK: Excel VBA 24-Hour Trainer 2nd edition 12 October 13th, 2015 05:23 PM
Code for Professional JSP 2nd Edition bmar All Other Wrox Books 22 July 7th, 2013 07:52 AM
Code of "Professional JSP 2nd Edition" yueliu Wrox Book Feedback 5 February 25th, 2005 03:38 AM
Code for Professional JSP 2nd Edition gop All Other Wrox Books 1 June 19th, 2004 03:59 PM
C# 2nd Edition Code Samples in VS.NET cjk68 BOOK: Professional C#, 2nd and 3rd Editions 0 July 18th, 2003 10:55 PM



All times are GMT -4. The time now is 12:08 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.