Disabling the Combo Box

  • Thread starter Thread starter Souny
  • Start date Start date
S

Souny

Good morning all,

I have a combo box in Sheet1 of my Excel file. What I like to do is to
disable the combo box so that when users click on it, nothing would happen
and selections would not display.

I would like to share a little background related to what I am looking for.
I have a code to perform a list of things on Sheet1 (and combo box is one of
those things). After a list of those things has performed, I want to disable
the combo box so that users can not revisit the combo box to make a selection
from it.

As part of my code, the code will check whether those things are performed.
If performed, the combox box will disable, and the users will receive a
message that since those things are performed, the combo box will not be
available.

Is it possible to disable the combo box? Could you help me with the code?

Thanks.
 
is this the activeX combo?

Sheet1.ComboBox1.Visible = False
or
worksheets("Sheet1").ComboBox1.Visible = False

with the forms control, set it to the macro, cnage the name appropriately

Sub DropDown2_Change()
With Sheet1.Shapes("Drop Down 2")
..Visible = msoFalse
End With
End Sub
 
Sam,

Thanks for the code. Is the code supposted to be:

Worksheets("Sheet1").comboxboxname.enabled = false

Thanks.
 
Patrick,

Thanks for the code. I am using activeX combo, not Forms combo.

If I use the following, would it make the combo box disappear?

worksheets("sheet1").combobox1.visible = false

I don't want it to disappear. I want it so that when users click on it,
nothing would happen.

Thanks.
 
Sam,

I got it. I misunderstood what you said. The code should be:

comboboxname.enabled = false

That is a very simple code. I didn't know that it would be that simple.

Thanks again.
 
ok
so change visible=False to enabled=False

Souny said:
Patrick,

Thanks for the code. I am using activeX combo, not Forms combo.

If I use the following, would it make the combo box disappear?

worksheets("sheet1").combobox1.visible = false

I don't want it to disappear. I want it so that when users click on it,
nothing would happen.

Thanks.
Click to expand...
 
Back
Top