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)
I've tried the whole day searching for the similar example, but
couldn't find any.
Thanks in advanced for any ideas.
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.