This will be helpful for you to enhance your learning. If you feel suitable provide me codes and their respective deisgn and I'll create the menu (command bar) for you. But still I want you to try this first by yourself, just to enhance your learning.. :)
-- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 2/27/10, Harpreet Gujral <harpreetguj...@gmail.com> wrote: > > Thanks Dilip, > > Just went thru the same link before going to bed, will work on the basis of > it tom. Neways, thanks mate. > > Will share with you the results of what I have learnt. > > Thanks once again > > Harpreet gujral > > Sent on my BlackBerry® from Vodafone Essar > ------------------------------ > *From: *Dilip Pandey <dilipan...@gmail.com> > *Date: *Fri, 26 Feb 2010 23:55:26 +0530 > *To: *<harpreetguj...@gmail.com> > *Cc: *<excel-macros@googlegroups.com> > *Subject: *Re: $$Excel-Macros$$ Re: Application.commandbars > > > Dear Harpreet, > > Try below link:- > http://www.ozgrid.com/VBA/custom-menus.htm > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > On 2/26/10, Harpreet Gujral <harpreetguj...@gmail.com> wrote: >> >> Dilip, >> >> I tried searching on the net for the codes, but was not as successfull as >> I thought I would be. >> >> If you can help me, can you provide me a link or a source which clearly >> states: >> 1) How to use this code? >> 2) How to make use of its sub properties. Eg: position (this is where more >> information is reqd) >> 3) Can you give me a sample code where I can create a menu bar, with a >> menu item and sub menu item. I.E I am looking for 3 levels of menu on a >> single menu. >> >> I hope I was able to explain my need. >> >> Thanks mate >> >> Harpreet >> >> Sent on my BlackBerry® from Vodafone Essar >> ------------------------------ >> *From: *Dilip Pandey <dilipan...@gmail.com> >> *Date: *Thu, 25 Feb 2010 23:30:20 +0530 >> *To: *<excel-macros@googlegroups.com> >> *Cc: *<harpreetguj...@gmail.com> >> *Subject: *Re: $$Excel-Macros$$ Re: Application.commandbars >> >> >> Dear Harpreet, >> >> I believe this is something related to menu creation using Excel-VBA. Try >> searching internet with changed string and you'll get many reasonable >> responses. :) >> >> Let me know if you need a sample code to create a menu button. >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> >> On 2/24/10, Harpreet Singh Gujral <harpreetguj...@gmail.com> wrote: >>> >>> Does anybody have access to complete information on Commandbars, and >>> all its properties. >>> >>> Please forward it to me >>> >>> Thanks >>> >>> Harpreet Gujral >>> >>> >>> On Feb 21, 7:56 pm, Harpreet Singh Gujral <harpreetguj...@gmail.com> >>> wrote: >>> > Hi, >>> > >>> > Can someboday help me with the commandbars? >>> > >>> > I am looking forward to create a custom commandbar with the help of >>> VBA. Can >>> > you please suggest a source to understand >>> > >>> > what all sub properties that we need to specify to make the commandbar. >>> Like >>> > position etc etc. >>> > >>> > Thanks >>> > >>> > Harpreet Gujral >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our Facebook Group @ >>> http://www.facebook.com/group.php?gid=287779555678 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,800 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> >> >> > > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
