Hi All,

I'm doing a function to import the Excel to Access database & vice versa using vb6.

If the cell in Excel is a list, I need to store the value as integer.
Example, List = {Yes, No}, if the selected value = Yes, then I'll store 0 in database.

Question 1: How do I check whether the cell is a list or not?
I've tried Range.Validation.Formula1, it'll return me the list (e.g. Yes,No).
For cell which does not contain list, it'll return error when I call Range.Validation.


Question 2: Can I get the selected value as integer? (such as in vb6 combobox)

I've tried the whole day searching for the similar example, but couldn't find any.

Thanks in advanced for any ideas.