| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ComboBox drop list when clicked on???????????
-- Tdp |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ComboBox drop list when clicked on???????????
How do I get a combobox to drop its list when clicked on?
-- Tdp "Tdp" wrote: -- Tdp |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ComboBox drop list when clicked on???????????
What is it doing now? Are you out of design mode?
-- ** John C ** "Tdp" wrote: How do I get a combobox to drop its list when clicked on? -- Tdp "Tdp" wrote: -- Tdp |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ComboBox drop list when clicked on???????????
Its working fine. I only want to stop users from typing in the box, I want
only to be able to use the dropdown list. -- Tdp "John C" wrote: What is it doing now? Are you out of design mode? -- ** John C ** "Tdp" wrote: How do I get a combobox to drop its list when clicked on? -- Tdp "Tdp" wrote: -- Tdp |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ComboBox drop list when clicked on???????????
I think if you go into the properties of the combo box, and change the style to
2 - fmStyleDropDownList it will accomplish your objective. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Tdp" wrote: Its working fine. I only want to stop users from typing in the box, I want only to be able to use the dropdown list. -- Tdp "John C" wrote: What is it doing now? Are you out of design mode? -- ** John C ** "Tdp" wrote: How do I get a combobox to drop its list when clicked on? -- Tdp "Tdp" wrote: -- Tdp |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ComboBox drop list when clicked on???????????
Your right!
It works well Thanks very much -- Tdp "John C" wrote: I think if you go into the properties of the combo box, and change the style to 2 - fmStyleDropDownList it will accomplish your objective. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Tdp" wrote: Its working fine. I only want to stop users from typing in the box, I want only to be able to use the dropdown list. -- Tdp "John C" wrote: What is it doing now? Are you out of design mode? -- ** John C ** "Tdp" wrote: How do I get a combobox to drop its list when clicked on? -- Tdp "Tdp" wrote: -- Tdp |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ComboBox drop list when clicked on???????????
Thanks for the feedback :)
-- ** John C ** "Tdp" wrote: Your right! It works well Thanks very much -- Tdp "John C" wrote: I think if you go into the properties of the combo box, and change the style to 2 - fmStyleDropDownList it will accomplish your objective. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Tdp" wrote: Its working fine. I only want to stop users from typing in the box, I want only to be able to use the dropdown list. -- Tdp "John C" wrote: What is it doing now? Are you out of design mode? -- ** John C ** "Tdp" wrote: How do I get a combobox to drop its list when clicked on? -- Tdp "Tdp" wrote: -- Tdp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| .AddItem list and populating combobox with created list | Excel Discussion (Misc queries) | |||
| Macro that Finds the First Value in a range using a Combobox (drop down menu) | Excel Worksheet Functions | |||
| Combobox drop down | Excel Discussion (Misc queries) | |||
| Combobox drop down | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
