*Hi Sursh,* You have to be TRICKY with excel. What I have done is explained below:- (Pls note that it may not be the standard approach, as I hv learned Excel and computers on my own and never went to any Institute.)
First create the command button, then create a test box on it. Format the text box with no lines and choose any color for the text box, but make it transparent. Now, the command button has the text box on it, but a person can not view it or recognize it easliy. Now, assign the hyperlink to the text box, which should be pointed to the same sheet. Edit the screen-tip of the hyperlink as per your choice and put - in your message. Now create the macro and assign that macro to the command box and to the text box -both. Cross -Check the entire piece and test the working. Note:- You need to do some tricks and formatting on excel to achieve this. Actually, I enjoy doing these type of things which usually seems to be like MISSION IMPOSSIBLE. ha ha..!! Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Fri, Jun 5, 2009 at 1:55 PM, suresh k <brave.sur...@gmail.com> wrote: > Hi Dilip, > > From this I am able to find out you have used Text box for pop up message > right. > But when I create it above the command button, I can see either of this > working. > Can you please let me know the the steps how you created this, that will be > big help for me. > > Many thanks > > Thanks & Regards, > Suresh > > > On Fri, Jun 5, 2009 at 1:43 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > >> *Dear Suresh,* >> >> I have checked it by creating a macro in the attached workbook. It is >> working fine. Please go through it once again. >> >> Note:- Macro name is "Suresh" which is assigned to the button. >> Note:- You might move your cursor to the upper area of the button, to see >> the help message pop-up. >> >> Thanks >> Dilip >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> On Fri, Jun 5, 2009 at 1:23 PM, suresh k <brave.sur...@gmail.com> wrote: >> >>> Hi Dilip, >>> >>> Many thanks for your reply. >>> >>> Its working, but when I assign some macros to that command button, I >>> cannot see the popup message. >>> Is there any other way for it. >>> >>> Thanks & Regards, >>> Suresh >>> >>> >>> On Fri, Jun 5, 2009 at 1:14 PM, Dilip Pandey <dilipan...@gmail.com>wrote: >>> >>>> Dear Suresh, >>>> >>>> Please find the solution attached in this email reply. >>>> I have given the explanation(s) in the attached workbook itself. >>>> >>>> Thanks, >>>> -- >>>> DILIP KUMAR PANDEY >>>> MBA-HR,B COM(Hons.),BCA >>>> Mobile: +91 9810929744 >>>> dilipan...@gmail.com >>>> dilipan...@yahoo.com >>>> New Delhi - 110062 >>>> >>>> >>>> >>>> On Thu, Jun 4, 2009 at 6:57 PM, suresh k <brave.sur...@gmail.com>wrote: >>>> >>>>> Hi Dilip, >>>>> >>>>> Can you please tell how to provide help if my cursor moves near command >>>>> button, it should show some message. >>>>> >>>>> Plese let me know how to do this in VB. >>>>> >>>>> Thanks & regards >>>>> suresh >>>>> >>>> >>>> >>>> >>> >> >> >> >> > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
