Combo Box copied from the net but i dont know how was it done ?

**uaeXuae** · 12-07-2007, 12:48 AM

Please see the picture by visiting

http://aycu38.webshots.com/image/351...6201860_rs.jpg

and the XLS file that i have uploaded. Any help gaining that design would be greateful.

**Leith Ross** · 12-07-2007, 12:56 AM

Hello uaeXuae,

What you "copied" is a worksheet cell with its Data Validation set.

Sincerely,
Leith Ross

**uaeXuae** · 12-07-2007, 12:59 AM

Thanx for your quick reply. I wonder how was it done ?. Is it possible that i do the same ? If so guide me through it.

Thanx In Advance.

**Paul** · 12-07-2007, 01:13 AM

Hi uae,

There are many ways to use Data Validation in Excel, so it might be worth your while to search the web for examples. One site that goes through a number of Data Validation examples is: http://www.contextures.on.ca/xlDataVal01.html