List Box or combo box into a cell
 

hi,

is there any way by which i can convert a particular cell, say A1 to list
box or combo box without using VBA control tools. i saw this type of
conversion in Autofilter option.

reg

List Box or combo box into a cell
 

Hi Aken,

Look at using Data Validation.

If you are not familiar with Excel's Data Validation featute, see Debra
Dalgleish's tutorial at:

http://www.contextures.com/xlDataVal01.html

---
Regards,
Norman



"aken" wrote in message
...
hi,

is there any way by which i can convert a particular cell, say A1 to list
box or combo box without using VBA control tools. i saw this type of
conversion in Autofilter option.

reg

List Box or combo box into a cell
 

thnaks it helped me to get the work done.

"Norman Jones" wrote:

Hi Aken,

Look at using Data Validation.

If you are not familiar with Excel's Data Validation featute, see Debra
Dalgleish's tutorial at:

http://www.contextures.com/xlDataVal01.html

---
Regards,
Norman



"aken" wrote in message
...
hi,

is there any way by which i can convert a particular cell, say A1 to list
box or combo box without using VBA control tools. i saw this type of
conversion in Autofilter option.

reg