Dear Noorain I have recd your
Actually I forgot to mention that the excel which I am using right now is Office 2003.So I can not use the excel sheet which you have sent for my help. Can you please send me the shore keys with Macro. B'caus to my understanding as per your sheet of command button I will have to create each command button for every text. If they are more in numbers then it will be difficult to handle the file. So if possible can you make a VBA Code List to avoid the repeating of typing the same text. Thanks for the help in advance. Nikhil On Tue, Sep 13, 2011 at 2:16 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Dear Nikhil, > > Please see attached sheet............. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > On Tue, Sep 13, 2011 at 11:32 AM, Nikhil Shah <nikhil201...@gmail.com>wrote: > >> Dear all, >> >> I want Help for creating the VBA Codes for Repeating of Text in my Excel >> sheet.. >> >> *Problem :* >> >> I have made excel sheet in Columns.In which I have some texts which are >> likely to repeat in my sheet frequently. So please help me to make proper >> Hot Keys to make my work fast and easy. >> >> Ex : Dividend, Growth , Fresh, Additional.....etc, there are suppose to be >> more then 25 Text which are repeating frequently. >> >> Suppose If I have to type dividend repeatedly then I press only Alt+d >> which means it will be automatically typed dividend any time and so on for >> other words also like Growth, Fresh..... etc. and for that I want VBA Code. >> >> Thanks for the help in advance. >> >> Nikhil >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 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 >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
