2012/5/2 Rajan_Verma <rajanverma1...@gmail.com> > Hi Chandru**** > > Please find the attached sheet, you can use list validation for that..**** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar > *Sent:* 02 May 2012 13:13 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Multi Combo Box**** > > ** ** > > Hello,**** > > **** > > Could you please help me on the attached file. Thanks in advance.**** > > **** > > Regards,**** > > **** > > Chandra Shekar B**** > > On Tue, May 1, 2012 at 3:39 PM, Rajan_Verma <rajanverma1...@gmail.com> > wrote:**** > > *HI Chandru,***** > > * ***** > > *File size will be very larege with 1000 controlls on worksheet.. I > suggest to use List Validation on each cell in your range***** > > * ***** > > * ***** > > * ***** > > *Regards***** > > *Rajan verma***** > > *+91 7838100659 [IM-Gtalk]***** > > **** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar > *Sent:* 01 May 2012 18:53 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Multi Combo Box**** > > **** > > Hello,**** > > **** > > I would like to have multi combo box on every row (1000 rows). Could you > please help me out on this.**** > > **** > > Thanks in advance.**** > > **** > > Regards,**** > > **** > > Chandra Shekar B**** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com >
*Specific guidance in the File* Right-click and select View Code Cobobox up the code window is accompanied by two lines of code: Private Sub ComboBox1_Change() End Sub Enter 5 lines of code into 2 lines of code between the [B16] = ComboBox1.Column(0) [C16] = ComboBox1.Column(1) [D16] = ComboBox1.Column(2) [E16] = ComboBox1.Column(3) [F16] = ComboBox1.Column(4) http://www.box.com/s/5ebf86d3541402f0c354 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
