Thread: editing listbox
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default editing listbox


Sounds like you are talking about a dropdown from data validation. This
only appears when the cell is selected.

An alternative would be to put a Dropdown from the forms toolbar on top of
the cell (remove the data validation). You could then link it to the cell.

--
Regards,
Tom Ogilvy


"xalbador" wrote in message
...
Hi!

I have made a listbox in a cell. I want to make "visible"
this listbox, because if you don't choose the cell where
it is located you cannot know that there is something
there. Nothing indicates you that there is an option to
choose.

How can I do this?