T
ts1
I have created a worksheet with about 40 ComboBox controls in each column of
A1 AO1. The ListFillRange populates from a different worksheet in the
workbook when a user selects drop down. I want to have a procedure associated
with each control that sets the ListFillRange for a second ComboBox control
under each one in A3-AO3.
The first set of controls in row 1 work fine to retrieve the ListFillRange.
As I started to add the second set of controls in row 2 with procedures I get
to a point where I start getting the following error when using the controls
in row 1 to populate it's ListFillRange.
Is there any limits on controls for a worksheet or configuration for amount
of resources needed for desired result.
Thanks
ts
"Not enough system resources to display completely"
A1 AO1. The ListFillRange populates from a different worksheet in the
workbook when a user selects drop down. I want to have a procedure associated
with each control that sets the ListFillRange for a second ComboBox control
under each one in A3-AO3.
The first set of controls in row 1 work fine to retrieve the ListFillRange.
As I started to add the second set of controls in row 2 with procedures I get
to a point where I start getting the following error when using the controls
in row 1 to populate it's ListFillRange.
Is there any limits on controls for a worksheet or configuration for amount
of resources needed for desired result.
Thanks
ts
"Not enough system resources to display completely"