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
MF - Transaction Dt.13-09-2011.xls
Description: MS-Excel spreadsheet
