ExcelBanter - Problem with lists

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Problem with lists (https://www.excelbanter.com/excel-worksheet-functions/57583-problem-lists.html)

TooBaaaadd

Problem with lists

My problem is probably very simple. When I create a list, it puts a border
around the range but the drop down arrow is only visible when the box is
selected. I have seen worksheet where there is no border and the drop down
arrow, that indicates there is a list, is visible all the time. How is this
accomplished.

Gord Dibben

Problem with lists

Try a ComboBox from the Control Toolbox.

ViewToolbarsControl Toolbox.

Gord Dibben Excel MVP

On Mon, 28 Nov 2005 06:57:02 -0800, "TooBaaaadd"
wrote:

My problem is probably very simple. When I create a list, it puts a border
around the range but the drop down arrow is only visible when the box is
selected. I have seen worksheet where there is no border and the drop down
arrow, that indicates there is a list, is visible all the time. How is this
accomplished.

All times are GMT +1. The time now is 12:37 PM.