Re: Could Not Set The Value Property. Invalid Property Value. Tabstrip Change Event
check the data as it may have incorrect entry
maybe set the name ranges up each time
Code
Private Sub myTab_Change()
Dim arrData, c As Long, i As Long
Dim itmLvl As Range, itm As Range
arrData = Worksheets("CALC").ListObjects("tbl_stats").DataBodyRange
i = myTab.SelectedItem.Index + 1
For c = LBound(arrData) To UBound(arrData)
If c = i Then
Call cbxItemLvl_Change
Call cbxItem_change
cbxItemLvl.Value = arrData(c, 2)
cbxItem.Value = arrData(c, 1)
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
Display More
but its getting messy .. what are we trying to do?