Need help to create a reference list

  • Thread starter Thread starter celia
  • Start date Start date
C

celia

Hi,

How can I create a list to be the reference to the data being entered
by the users?

The situation now is, the users are required to enter some data in
column A.

So I would like to create a list in a hidden sheet to compare the data
entered in order to prevent they entered the wrong data or invalid
data. (actually is like 1100, 1100(A), 1200...)

If there is any unmatched data, then users have to enter the data
again.

I know can do with data validation drop-down list but what if I don't
want to use drop-down list? Any suggestion of method to do this?

Thanks for any help.
 
celia > said:
So I would like to create a list in a hidden sheet to compare the data
entered in order to prevent they entered the wrong data or invalid
data. (actually is like 1100, 1100(A), 1200...)

If there is any unmatched data, then users have to enter the data
again.

I know can do with data validation drop-down list but what if I don't
want to use drop-down list? Any suggestion of method to do this?
Click to expand...

A very odd question. The question you pose is ideal for Data Validation, and
yet you say you do not want to use DV.

Can I ask why, what is DV not doing that you want to do? Comboboxes and
event code could do the same job, but the effect would be the same and would
be far more work.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top