View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Combobox Dropdown method

Can we see the code? what sort of combo, forms or control toolbox?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


wrote in message
oups.com...
All,

I have a combo box on a worksheet, which is made visible if a
particular cell is selected, I added the dropdown method to display the
combo box with the list automatically visible should someone select
that cell, the only problem is that if the user clicks on another cell
without selecting some thing from the combobox the list doesn't go
away. I have some code that makes the combobox invisible again but
cannot find a method to close the list. Anyone got any ideas?

Cheers in advance,

James