Dear Friend, Wow..Super..Excellent Code..This is very very helpful me..it 's save my time for retyping of Text..
Thanks for all members for solving my problem.. Nikhil On Wed, Sep 14, 2011 at 1:35 AM, Sam Mathai Chacko <samde...@gmail.com>wrote: > Nikhil, > > insert a module, and paste this code > > Sub Auto_Open() > > Application.OnKey "+g", "'RunMe ""g""'" > Application.OnKey "+d", "'RunMe ""d""'" > Application.OnKey "+a", "'RunMe ""a""'" > Application.OnKey "+f", "'RunMe ""f""'" > Application.OnKey "+r", "'RunMe ""r""'" > > End Sub > Sub Auto_Close() > > Application.OnKey "+g" > Application.OnKey "+d" > Application.OnKey "+a" > Application.OnKey "+f" > Application.OnKey "+r" > > End Sub > Sub RunMe(strKey As String) > > Select Case strKey > Case "d" > Selection.Value = "Dividend" > Case "g" > Selection.Value = "Growth" > Case "a" > Selection.Value = "Additional" > Case "f" > Selection.Value = "Fresh" > Case Else > Selection.Value = "Dividend Reinvestment" > End Select > > End Sub > , then reopen the saved file. > > Now select any cells and press SHIFT+d to write "Dividend" in the selected > cells, similarly for other words. Note that you cannot use ALT > > Regards, > Sam Mathai Chacko (GL) > > > On Tue, Sep 13, 2011 at 10:50 PM, Nikhil Shah <nikhil201...@gmail.com>wrote: > >> Dear All, >> >> As per your E-mail I am sending here with an Excel Sheet Attachment in >> which I have shown what exactly I want. >> ( see column No.... ' O ').. >> >> Thanks. >> >> Nikhil >> >> >> On Tue, Sep 13, 2011 at 7:47 PM, dguillett1 <dguille...@gmail.com> wrote: >> >>> Perhaps you could simply use a DATA VALIDATION list to select the >>> item( tied to a CHANGE_EVENT macro. Send me your file with a clear >>> explanation and before/after examples >>> >>> >>> *From:* Nikhil Shah <nikhil201...@gmail.com> >>> *Sent:* Tuesday, September 13, 2011 9:02 AM >>> *To:* excel-macros@googlegroups.com >>> *Cc:* noorain.ans...@gmail.com >>> *Subject:* Re: $$Excel-Macros$$ VBA Code For Repeating Of Text >>> >>> 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 >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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 >> > > > > -- > Sam Mathai Chacko > > -- > > ---------------------------------------------------------------------------------- > 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
