Excel and using the Form facility

  Durko 12:04 11 Dec 2006

When using the Data-Form facility using criteria to enter address details like organisation, address, contact etc, is it possible to configure so it recognises words and inserts them automatically. e.g. When not using the form you can enter London,Birmingham etc initially and then it picks them up when entering them again and inserts them for you.

Hope you get my drift...using excel 2003 if it helps.

Advice would be much appreciated


  keith-236785 12:16 11 Dec 2006

isnt that "auto complete", or do you want to set a range of keywords that are recognised, maybe the use of a combo box to allow you to choose from a list?

just a few ideas, i have no idea how to implement them but im sure someone will.

  Durko 12:38 11 Dec 2006


Options is set to autocomplete but entering repetetive data such as London, Wales, Birmingham, Oxfam, etc in normal fashion without the form utility they repeat in cells ok. Just need to know why not when using the form facility and is there a way round it.

Thanks for your help anyway.

Perhaps VOG has the answer...


  VoG II 12:41 11 Dec 2006

Sorry no - I've never used the Forms facility.

  Durko 12:52 11 Dec 2006


Thanks anyway.


  VoG II 19:07 11 Dec 2006

As nobody seems to know, try asking at MrExcel click here

  Mr Mistoffelees 19:14 11 Dec 2006

to which VoG™ doesn't know the answer!

Must pinch myself to see if I am awake.... Ow! Yes!

  lindyloo4 20:59 11 Dec 2006

Not very good with excel but if the data you wish to be repeated is in the same column can you right click and select Pick from list.

  Woolwell 22:39 11 Dec 2006

Perhaps a drop down list would be helpful
click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?