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

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Hi,

Its from the control toolbox, the code is run from the worksheet
selection change event, basically its to replace the in cell validation
that I was using, the reason I went down this route was that the sheet
is zoomed to about 70% and at this level the validation is barealy
ledgible. The code is:

ActiveSheet.CellMenu.Top = ActiveCell.Top + 18
ActiveSheet.CellMenu.Left = ActiveCell.Left
ActiveSheet.CellMenu.Visible = True
ActiveSheet.CellMenu.DropDown
ActiveSheet.CellMenu.ListIndex = -1

Then if the user clicks on another cell then I just make the combobox
inivisible but the dropdown doesn't go away as the user hasn't clicked
anything. The CellMenu is just a comob box that has an onclick event
that puts the value of the combobox in the activecell.

Cheers,

James

Bob Phillips wrote:
> Can we see the code? what sort of combo, forms or control toolbox?
>
> --
> ---
> HTH
>
> Bob
>
> (change the xxxx to gmail if mailing direct)
>
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >