Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combo box, select item, auto create another combo box in field | Excel Programming | |||
Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet | Excel Programming | |||
Excel VBA Combo Box Populating dependent on other combo box choices | Excel Programming | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
disabling the Files type combo box | Excel Discussion (Misc queries) |