Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the Combo Box
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the Combo Box
add this to the end of your code:
cmb_YourComboBox.Enabled = false "Souny" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the Combo Box
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 "Souny" wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the Combo Box
Sam,
Thanks for the code. Is the code supposted to be: Worksheets("Sheet1").comboxboxname.enabled = false Thanks. "Sam Wilson" wrote: add this to the end of your code: cmb_YourComboBox.Enabled = false "Souny" wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the Combo Box
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. "Patrick Molloy" wrote: 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 "Souny" wrote: 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the Combo Box
ok
so change visible=False to enabled=False "Souny" wrote: 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. "Patrick Molloy" wrote: 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 "Souny" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |