ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   editing listbox (https://www.excelbanter.com/excel-programming/304554-editing-listbox.html)

xalbador

editing listbox
 
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?

Tom Ogilvy

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?





All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com