> 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 with 11
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
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
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
Hi Expert,
I need your help, I have one multipage with 11 combo boxes. all combo box
have same value, value are "Yes", "No", "Don't No".
there is one combo box called "All"
what I want is that suppose user select("Yes") value from "All" combo box,
other combo boxes value should be same ("Yes") as
