Combo box range change

  • Thread starter Thread starter saman110 via OfficeKB.com
  • Start date Start date
S

saman110 via OfficeKB.com

hello,

I have two combo boxes in sheet1 and data in two columns in sheet2. I set the
first combo box to the column A of sheet2 and the second combo box to Col.B
of sheet2, then when I Filter the Col.B the combo box in sheet1 does not
change. Is there any way I could get the combo box to update to the dynamic
Col.?

Thx.
 
Try this:

Use a formula to define a dynamic named range.

1. Hit CTRL+F3

2. Name = Items (for example)

3. Refers to: =OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A),1)
 
hi,

unfortunatly for some reason it does not work for me. Is there a macro to
force the combo box to get a dynamic range?

thx.
Try this:

Use a formula to define a dynamic named range.

1. Hit CTRL+F3

2. Name = Items (for example)

3. Refers to: =OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A),1)
hello,
Click to expand...
[quoted text clipped - 5 lines]
Thx.
Click to expand...
Click to expand...
 
Back
Top