AutoCoplete cells content

  • Thread starter Thread starter MassimoM
  • Start date Start date
M

MassimoM

Hello ng reader,
I was wondering if it is possible to help users to fill cells content.
Let's say I have a column and the user has to write something from a
set of words.
I would like to help the user showing a box which shows all the words
matching the characters he/she has already typed. Like when we use VBE
in Excel.
The set of words could come from a specified range or an array defined
in VBA.

Is it possible ?

Thanks,
Massimo
 
Have you tried Data>Validation>List
Then in the RefersTo box enter (with the equal sign)
=MyRange ' (a user named range)

In your MyRange list on any sheet list the options that a user could choose
from.
This limits the options, but avoids typos and presents the user with
acceptable choices.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to delete cell contents EXCEPT for last 5 characters 1
Conditionally-like formatting just a part of a cell 4
making one cell show contents of other selected cells...automatica 2
CONCATENATING CELL CONTENTS ! 2
Rename sheet with content in specific cell 4
Excel Import Comments 3
Read contents of #Name cell 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0

Back
Top