|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
|
Hello,
I have opened an excel file into a .net application and any trying to determine if column 1 is a checkbox or not. Spreadsheet column 1 has both Text and Checkboxes. This is what I have tried to far with no success: For Lines = 1 To xlSht.Cells.Rows.Count xlRng = xlSht.Cells(Lines, 1) If xlRng.Value.GetType is boolean Then xlRng = xlSht.Cells(Lines, 2) End If Next Actually I have tried lots of different ways to determine this and have run out of ideas, Any assistance will be greatly appreciated. Thanks, Chuck |
|||||||||||||||||||||||