Hi Noorain, Thank you for this , one doubt here can we Have a faded or shaded check box instead if hiding them?
Thanks Prasad. On Tue, Sep 6, 2011 at 12:07 AM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Dear Surya, > > Please see attached sheet if it help to u.. > > ---------- Forwarded message ---------- > From: <suryaprasad...@gmail.com> > Date: Mon, Sep 5, 2011 at 11:15 PM > Subject: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes > To: excel-macros@googlegroups.com > > > **Hi all, > > Can anyone help me on this?? > > Regards > > Prasad > > Sent from BlackBerry® on Airtel > ------------------------------ > *From: *Mr Excellent <suryaprasad...@gmail.com> > *Date: *Mon, 5 Sep 2011 17:10:47 +0530 > *To: *<excel-macros@googlegroups.com> > *Subject: *Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes > > Hi Noorain, > > This helped me a lot but there is a single case in the code, how to add > many cases if the select any other country and opt for other check boxes, > please refer to the attachment > > Please help > > Thanks > Prasad. > > On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI > <noorain.ans...@gmail.com>wrote: > >> Dear Surya, >> >> Please see attached sheet if it help.. >> >> On Mon, Sep 5, 2011 at 7:06 AM, Mr Excellent >> <suryaprasad...@gmail.com>wrote: >> >>> Hi Group, >>> >>> Need a small help, i have a combo box in the form and when i click on >>> particular name "INDIA" one of the list box which says " Indian currency to >>> be updated " should be enabled and the other list box should be disabled and >>> vice versa as well, please help. >>> >>> Thanks, >>> Prasad. >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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://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 >> > > -- > > ---------------------------------------------------------------------------------- > 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://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 > -- ---------------------------------------------------------------------------------- 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
