Dear all Today I have recd Two Tricks for Retyping of Text..
( 1 ). With help of Data validation ( 2 ). VBA Code Thanks Nikhil On Wed, Sep 14, 2011 at 1:42 AM, Nikhil Shah <nikhil201...@gmail.com> wrote: > 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
