Check data in an Excell Cell

[grabrail]

Hi

A colleague of mine is struggling witha bit of code.

Basically he has an excell spreadsheet that has a dropdown box with various values

He needds a bit of VB code to check if entered data is actually in this list of data.

EG

Data = a,b,c,d,e,f

entered data is g

code should be something like.

if entered data not in list of data then

Can anybody help me here.

Cheers J

 

[SkipVought]

Hi,

An Excel dropdown box could be one of severa objects...

Control Toolbox

MS Form

Data/Validation

Depending on the type of object, you much check the ListFillRange to determine if it's pointing to a RANGE or if the values have been loaded by the AddItem method.

Skip,

_[red][/red]

 

[grabrail]

Hi

It appears the drop down box is a standard list box

Cheers

 

[SkipVought]

There is no such OBJECT as a "standard list box"

It is one of the afore mentioned 3. Which one?


Skip,

_[red][/red]