How to check if an Excel cell is a list(combo box)?

K

kaka135

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) :confused:

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

Thanks in advanced for any ideas.
 

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

Top