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