how to create search suggestion drop down list in mac excel

Take a look at Debra Dalgleish's site here:

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

she shows how to use a combo box which has the AutoComplete feature.

Hope this helps.

Pete

thank you but problem is after i active combo box on worksheet... am not able to see any property after right click

I don't know how a Mac differs from a PC, so I can't help you with that - sorry.

Pete

see below link for autocomplete in dropdownlist.

http://www.extendoffice.com/document...ocomplete.html

Hi,

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

In the above link the autocomplete feature using combo box.

But i need create a autocomplete feature in a cell.

If anybody know pls share.

Regards
Prasanna