Validating TextBox Entries

[Guest]

I have a textbox that I want to restrict to data within a given range on
another spreadsheet. This data is in the form of a list of unique
identifiers. Thus

4444444
5555555
6666666
7777777

I want to restrict the textbox to the above entries, giving a warning if an
invalid number is typed in the textbox. Is this possible or would it be
easier for me to use a ComboBox?

Many Thanks

 

[Frank Kabel]

Hi
lest assume your list is in A1:A3 and your validation cell is B1 then
- select B1
- goto 'Data - Validation' and enter the following formula
=COUNTIF($A$1:$A$3,B1)

 

[Guest]

Thank you Frank,

This works well on a cell but I really need to be able to validate the entry
in a textbox on a userform I have created. Any ideas?

Thanks Andy

 

[Dave Peterson]

As a user, I think I'd rather use a combobox. I don't have to struggle to make
sure I typed the value correctly.

And it should make your life as the developer a little easier, too.

 

[Guest]

Thanks for the feedback Dave,

ComboBox it is then.

Regards

Andy