Re: $$Excel-Macros$$ Code to control the database not to accept repeated number
thank you all very muchh On Fri, Sep 9, 2011 at 10:51 AM, Venkat CV venkat1@gmail.com wrote: Hi Bheema, See below image and Try Data Validation and use custom and formula as * =COUNTIF(C:C,C1)=1* [image: image.png] *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71 * * * On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar shankar.n...@gmail.comwrote: I made a userform. linked it with the datasheet. the filenumber acts as a bridge between userform and datasheet. I have to make the file number unique in excel. Because the duplicate numbers also accepting by the datasheet. If it happened so, my intention will not fulfill. So kindly provide solution to make the filenumber column of the datasheet as unique. -- -- 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 image.png
RE: $$Excel-Macros$$ Code to control the database not to accept repeated number
Use COUNTIF to check filenumber is unique : =COUNTIF(the filenumber column,filenumber)=0 Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Bheema Shankar Envoyé : mardi 6 septembre 2011 16:40 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Code to control the database not to accept repeated number I made a userform. linked it with the datasheet. the filenumber acts as a bridge between userform and datasheet. I have to make the file number unique in excel. Because the duplicate numbers also accepting by the datasheet. If it happened so, my intention will not fulfill. So kindly provide solution to make the filenumber column of the datasheet as unique. -- -- 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
Re: $$Excel-Macros$$ Code to control the database not to accept repeated number
Dear Bheema, Please see attached Sheet... On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar shankar.n...@gmail.comwrote: I made a userform. linked it with the datasheet. the filenumber acts as a bridge between userform and datasheet. I have to make the file number unique in excel. Because the duplicate numbers also accepting by the datasheet. If it happened so, my intention will not fulfill. So kindly provide solution to make the filenumber column of the datasheet as unique. -- -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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 Duplicate Entry.xlsm Description: Binary data
Re: $$Excel-Macros$$ Code to control the database not to accept repeated number
Hi Bheema, See below image and Try Data Validation and use custom and formula as * =COUNTIF(C:C,C1)=1* [image: image.png] *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar shankar.n...@gmail.comwrote: I made a userform. linked it with the datasheet. the filenumber acts as a bridge between userform and datasheet. I have to make the file number unique in excel. Because the duplicate numbers also accepting by the datasheet. If it happened so, my intention will not fulfill. So kindly provide solution to make the filenumber column of the datasheet as unique. -- -- 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 image.png
$$Excel-Macros$$ Code to control the database not to accept repeated number
I made a userform. linked it with the datasheet. the filenumber acts as a bridge between userform and datasheet. I have to make the file number unique in excel. Because the duplicate numbers also accepting by the datasheet. If it happened so, my intention will not fulfill. So kindly provide solution to make the filenumber column of the datasheet as unique. -- -- 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