AUTO FILL CELLS

[rgandy]

All,
Is there a way to have a custom list, for example

{Apple, Berry, Cherry, Sam}

and have corresponding cells that, when typed into, automatically populate with contents from the custom list?

For example, the user can type an "a" into cell A1, and the cell will allow the option to fill with "Apple"

I appreciate any help. Thanks

 

[SkipVought]

Hi,

Check out Data/Validataion - List.

Skip,
[sub]
[red][/red]
[/sub]

 

[firefytr]

Hi there,

This is tricky to do automatically. Check out this VBAX KB entry...

http://vbaexpress.com/kb/getarticle.php?kb_id=244

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci