Could Not Set The Value Property. Invalid Property Value. Tabstrip Change Event

Hi Ozgrid Experts,

I'm new to VBA Excel and I'm currently working on this little stats calculator but I'm stuck on my Tabstrip Change Event. I'm getting an error when I'm trying to read value from a table.
First load is ok. When I open the form it will show no data on the first tab then if I change to any tab then go back to first tab it will load the values without a problem, but after I change to another tab and go back again to the first tab, it will throw a Could Not Set The Value Property error.

Just to give you an idea of what I want to do. The user will enter data from various controls and it'll save those data a table in my 'Calc' sheet then the macro will pull those data again when the tab is active again. Hopefully I making any sense. It's basically a little database that will be use to record the user input. Thanks!

Private Sub myTab_Change()
    
    Dim arrData, c As Long, i As Long
    arrData = Worksheets("CALC").ListObjects("tbl_stats").DataBodyRange
    i = myTab.SelectedItem.Index + 1
    For c = LBound(arrData) To UBound(arrData)
        If c = i Then
            cbxItem.Value = arrData(c, 1)
            cbxItemLvl.Value = arrData(c, 2)
            cbxAttrb1.Value = arrData(c, 3)
            tbxAttrb1.Value = arrData(c, 4)
            cbxAttrb2.Value = arrData(c, 5)
            tbxAttrb2.Value = arrData(c, 6)
            cbxAttrb3.Value = arrData(c, 7)
            tbxAttrb3.Value = arrData(c, 8)
            cbxAttrb4.Value = arrData(c, 9)
            tbxAttrb4.Value = arrData(c, 10)
            lblBns.Caption = arrData(c, 11)
            lblBnsVal.Caption = arrData(c, 12)
        End If
    Next c
End Sub

Re: Could Not Set The Value Property. Invalid Property Value. Tabstrip Change Event

Wow. I never thought that it would affect the tabstrip. My problem now is the ComboBox keeps adding new data in the list.

EDIT: After several tries, again it throws out the same error even after commenting out the .Clear

Re: Could Not Set The Value Property. Invalid Property Value. Tabstrip Change Event

Hi Pike,

Yes, there's a loop inside a combobox event because the combobox value is dependent to another combobox. Thus, the .Clear. But yeah, even after commenting it out it still throws the same error.

Re: Could Not Set The Value Property. Invalid Property Value. Tabstrip Change Event

I used the Tabstrip because I'm using the same controls for 8 items. I'm reading between data through the Tabstrip Index.

EDIT: I'll take a look into that. Thanks for all the replies.

Re: Could Not Set The Value Property. Invalid Property Value. Tabstrip Change Event

Hi Pike,

I just tested it and it seems to work fine if at initialize the default tab is the first tab. But if I left it and save it with a different active tab, the next time I open it, it throws the same error again.

@Grimes,

It should be getting the value from the Tabstrip Change event. So, I'm not really sure why I'm getting the error.

Re: Could Not Set The Value Property. Invalid Property Value. Tabstrip Change Event

I was scanning the code carefully and I notice that mixed up the 2 range.

If i = 0 Then
        Set itmLvl = ThisWorkbook.Names("wpLvl").RefersToRange
        Set itm = ThisWorkbook.Names("wp").RefersToRange
    Else
        Set itm = ThisWorkbook.Names("suit").RefersToRange
        Set itmLvl = ThisWorkbook.Names("suitLvl").RefersToRange
    End If

Hopefully, this will solve it all. Thank you for all the help Pike and Grime.

Re: Could Not Set The Value Property. Invalid Property Value. Tabstrip Change Event

Yeah, still the same. There's a conflict with the values when reading through the 'Calc' table.

[ATTACH=CONFIG]68812[/ATTACH]
arrData(c, 3)'s value is from different set of item. It's not getting updated properly.

Re: Could Not Set The Value Property. Invalid Property Value. Tabstrip Change Event

Quote from pike;768922

looking like it has solved the error
well done

arrrr what is if for?

that if is to determine which Tab is active. if it's 0 then the DropDown will use the tbl_weapon, if not then it will use the tbl_suit.