How can i fill a cell automaticaly by entering the few letters?

Posted by steve on May 14, 2001 7:37 AM

Is it possible to specify an array for a specific cell to facilitate
the trade entry process?

Ex: In cell A1, if I type B, I would like the cell to be filled with BTRADE?

Thanks

Posted by Kevin James on May 14, 2001 8:18 AM

Hello Steve,

Using your Excel help facility, search on Validation. I think it is what you want.

Kevin

Posted by Steve on May 14, 2001 8:43 AM

Hi Kevin,

By using validation it creates a combo box, but the box is not filled
automaticaly when I enter only the first few letters.

Styves

Posted by Kevin James on May 14, 2001 9:48 AM

Hi Styves,

See the email I just sent you.

Kevin

Posted by Stu on May 14, 2001 11:28 AM

I was also interested in hearing this solution. It would be helpful to a spreadsheet I am working on where I am now using drop-down list. Is there another way such as the "quick-fill" used in Quicken, where after a few letters are typed in the cell the user is offered choices that most closely match his keystrokes?

Posted by Kevin James on May 14, 2001 5:20 PM

Stu:

I'd be happy to send you a sample but I have noted that in all your postings you've never included an email address.

Kevin

Posted by Stu on May 14, 2001 6:51 PM

Sorry,
My email is now included and I look forward to the sample.

Thanks,
Stu