How to create drop down list having options to the right of cell

[Vipul Vashisht]

hi
i want to create drop down list having options to the
right of cell so that i neded not type evey option in the
cells below in the column. pls tell me how is it possible.
Thanks
Vipul

 

[Dan E]

Vipul,

You might want to have a look here
http://www.contextures.com/xlDataVal01.html

Dan E

 

[Vipul]

Thanks. How can I get the heading of the list in the same
cell.

I want like this Employees( should be cell heading)>>>>
Then pop down list having list of 15 employees in the same
cell. By default only Employees should be visible in this
cell. In the cells below I should be able to choose any
employeee based on the drop down menu

Thanks
Vipul

-----Original Message-----
Vipul,

You might want to have a look here
http://www.contextures.com/xlDataVal01.html

Dan E

"Vipul Vashisht" <[email protected]>

wrote in message [email protected]...

 

[Debra Dalgleish]

Before you apply data validation to the cell, type 'Employees' in it.

Or, include 'Employees' in the list of employees, and choose it after
data validation has been applied.

 

[Vipul Vashisht]

HI
That is happening But once I select any name from drop
down list the default heading is no more there. The
default heading should always remain selected
Also the drop down arrow should be permanently visible ,
it is visible only when the cell is selected. The default
option along with drop down arrow should always be visible
and on dropping down the caption cell , you should be able
to view only the list names but should not be able to
select the name from drop down list in the caption cell.
Pls help
Thanks
Vipul

 

[Debra Dalgleish]

The arrow in a cell with a data validation list is only visible when the
cell is active. For an arrow that's visible at all times, you could use
the combobox from the forms toolbar or the control toolbox.

You could use programming to take the name that's been selected, place
it in another cell, and return the combobox to the default setting.

Or, enter the "Employee' heading in one cell, and use a data validation
list in an adjacent cell, where the user can select a name from the
dropdown list.