Use of Dictonary Objects in Excel macro

[kandanuru]

Hello Every one,

Can any please help me on this:

When i am typing Apple in excel cell i should get all the Dictionary values corresponding to "A" . When i type A all the dictonary values corresponding to "A" should be displayed and i need to select Apple from the display.

Please help me in giving an VBA code to implement the same in Excel for the requirement.

Regards,
Kandanuru

 

[xenou]

Dictionary objects aren't actually dictionaries - unless you put a dictionary's worth of words in one. Smart autocomplete for indeterminate input is more of a google thing than an excel thing.

 

[kandanuru]

Re: Use of Dictonary values in Excel macro

I shall change and put my question like this.

When i am typing Apple in excel cell i should get all the Dictionary values corresponding to "A" . When i type A all the dictonary values corresponding to "A" should be displayed and i need to select Apple from the display.

Please help me in giving an VBA code to implement the same in Excel for the requirement.

Regards,
Kandanuru

 

[Jaafar Tribak]

Take a look here . (Post #12 for a workbook demo)