Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
This line of code (in red) is causing me problems. It breaks with a "Could not set the List property. Invalid property array index." error as I try to assign a range of values as a list source for a combobox on my userform.
Thought of the problem and how to fix?
Rich (BB code):
Case Is = "League1 (OSA)"
Stop
Set nr_calibre = ws_lists.Range("G2:G2") 'rep
Set nr_dvsion = ws_lists.Range("H139:H139") 'U21 M/W League 1
t = 3
bigandbad t '{frm_chg_3League}
permit.cbx_calibre = "REP"
permit.cbx_division = "U21 M/W League 1"
permit.cbx_f2_fc.Enabled = True
permit.cbx_f2_gl.Enabled = True
permit.cbx_f2_fc.List = ws_lists.Range("U2:U19")
permit.cbx_f2_fc.Value = "S1 - 91.5m x 61m"
permit.cbx_f2_gl.List = ws_lists.Range("V2:V15")
permit.cbx_f2_gl.Value = "S1 - 24'"
Thought of the problem and how to fix?