Locked combobox

MARTI MARTI · Jan 2nd 2016

Hello every one
Please if you can help me ..
How to correct the code so that if I do not check OptionButton1 or OptionButton2 then the combobox1 will be Locked
Thank you in advance for help me
Cordially
MARTI MARTI
forum.ozgrid.com/index.php?attachment/67900/

**Carim** · Jan 2nd 2016

Re: Locked combobox

Hi Marti,

You could test ...

Code

Private Sub Frame1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
ComboBox1.Locked = False
If OptionButton1.Value = False And OptionButton2.Value = False Then ComboBox1.Locked = True
End Sub

HTH

MARTI MARTI · Jan 2nd 2016

Re: Locked combobox

Hiiii Carim
Nice to meet you again
Thank you Carim for help and for your best code and for your precious time sacred for help me
It is resolved
Cordially
MARTI MARTI
[ATTACH=CONFIG]67901[/ATTACH]

**mikerickson** · Jan 2nd 2016

Re: Locked combobox

Using If statements to set boolean values is a pet peeve of mine. This would also work

Code

Private Sub Frame1_Exit(ByVal Cancel As MSForms.ReturnBoolean) 
    ComboBox1.Locked = (OptionButton1.Value Or OptionButton2.Value)
End Sub

MARTI MARTI · Jan 2nd 2016

Re: Locked combobox

Hiiii mikerickson
HAPPY NEW YEAR 2016
Thank you very very much for your best code
Cordially
MARTI MARTI
[ATTACH=CONFIG]67902[/ATTACH]

Locked combobox

Participate now!

Share