| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DropDown
Hi
I need to prevent the DropButtonClick event under certain circumstances existing elsewhere on a userform without using the other controls exit events with Cancel = True. I do not want to disable or lock the combobox either. Syntax like ComboBox1.DropDown = False doesn't have any effect. Is there a way? T.I.A. Geoff |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DropDown
ComboBox1.Enable = False
Mangesh "Geoff" wrote in message ... Hi I need to prevent the DropButtonClick event under certain circumstances existing elsewhere on a userform without using the other controls exit events with Cancel = True. I do not want to disable or lock the combobox either. Syntax like ComboBox1.DropDown = False doesn't have any effect. Is there a way? T.I.A. Geoff |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DropDown
sorry, missed the "d"
ComboBox1.Enabled = False Mangesh "Mangesh Yadav" wrote in message ... ComboBox1.Enable = False Mangesh "Geoff" wrote in message ... Hi I need to prevent the DropButtonClick event under certain circumstances existing elsewhere on a userform without using the other controls exit events with Cancel = True. I do not want to disable or lock the combobox either. Syntax like ComboBox1.DropDown = False doesn't have any effect. Is there a way? T.I.A. Geoff |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DropDown
Hi
No, as I said in my post I do not want to disable the cbobox. If it is disabled or locked then a click event on the cbobox cannot be recognised. Geoff "Geoff" wrote: Hi I need to prevent the DropButtonClick event under certain circumstances existing elsewhere on a userform without using the other controls exit events with Cancel = True. I do not want to disable or lock the combobox either. Syntax like ComboBox1.DropDown = False doesn't have any effect. Is there a way? T.I.A. Geoff |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DropDown
Then try setting a flag which changes to TRUE or FALSE as per your
condition, and then in the click event check the status of the flag. Mangesh "Geoff" wrote in message ... Hi No, as I said in my post I do not want to disable the cbobox. If it is disabled or locked then a click event on the cbobox cannot be recognised. Geoff "Geoff" wrote: Hi I need to prevent the DropButtonClick event under certain circumstances existing elsewhere on a userform without using the other controls exit events with Cancel = True. I do not want to disable or lock the combobox either. Syntax like ComboBox1.DropDown = False doesn't have any effect. Is there a way? T.I.A. Geoff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
| Dropdown box display only data dependent on another dropdown box? | Excel Worksheet Functions | |||
| Dropdown List within a dropdown | Excel Worksheet Functions | |||
| offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
| How do I create a dropdown within a dropdown? | Excel Discussion (Misc queries) | |||
Linear Mode
