Re: $$Excel-Macros$$ Dependent Combo box

2014-02-23 Thread Rupesh Patil
Dear Ravinder, Thanks your quick reply. I got same error. at ufmailfrom.Controls(cntrl.Name).Value = ufmailfrom.cb_all.Value line Run time error 380. On Mon, Feb 24, 2014 at 10:40 AM, Ravinder wrote: > PFA. IF HELPS > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegro

RE: $$Excel-Macros$$ Dependent Combo box

2014-02-23 Thread Ravinder
PFA. IF HELPS From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Saturday, February 22, 2014 4:51 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dependent Combo box Hi Expert, I need your help, I have one multipage

Re: $$Excel-Macros$$ Dependent Combo box

2014-02-23 Thread Rupesh Patil
Dear Ashish, Thanks you very much. I tried you code and I got this run time error "Run time Error '380' could not set the value property. Invalid property value". could you please assist me why this error come. Thanks and regards, Rp On Sat, Feb 22, 2014 at 7:13 PM, ashish koul wrote: > Priv

Re: $$Excel-Macros$$ Dependent Combo box

2014-02-22 Thread ashish koul
Private Sub cb_all_Change() Dim cnt As Control If Me.cb_all.Value = "Yes" Then For Each cnt In Me.Controls If TypeName(cnt) = "ComboBox" Then cnt.Value = Me.cb_all.Value End If Next End If End Sub On Sat, Feb 22, 2014 at 4:50 PM, Rupesh Patil wrote: > Hi Expe