Dear all I have recd answer..
* http://www.contextures.com/excel-videos-data-validation-basics.html#dropdown * Excellent trick..How to Use Conditional formula with data-validation.. Thanks..Give me Idea.. Nikhil Shah On Tue, Sep 13, 2011 at 11:29 PM, Nikhil Shah <nikhil201...@gmail.com>wrote: > Dear > > Can you tell how i use data validation function on another sheet..I try but > it show error.. > > awaiting reply > > nikhil > > > On Tue, Sep 13, 2011 at 11:17 PM, dguillett1 <dguille...@gmail.com> wrote: > >> Here is a sheet using Data Validation as I suggested.Much easier and >> easier to change. >> >> *From:* Nikhil Shah <nikhil201...@gmail.com> >> *Sent:* Tuesday, September 13, 2011 12:20 PM >> *To:* excel-macros@googlegroups.com >> *Cc:* noorain.ans...@gmail.com >> *Subject:* Re: $$Excel-Macros$$ VBA Code For Repeating Of Text >> >> 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
