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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200709/1

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)


"saman110 via OfficeKB.com" wrote:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200709/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.

Tim wrote:
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,

[quoted text clipped - 5 lines]

Thx.

--
Message posted via http://www.officekb.com

Hi,

Have a look at this link:

http://www.excelforum.com/showthread.php?t=394521

tim


"saman110 via OfficeKB.com" wrote:

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.

You can also have a look he

http://forums.techguy.org/business-a...rowsource.html


"saman110 via OfficeKB.com" wrote:

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.

Hello,

Maybe you can try this thread.
J Latham helped me out.

http://www.microsoft.com/office/comm...=en-us&m=1&p=1

OR Search:

Is it possible to create a dynamic range in CONTROL TOOLBOX (form)
8 posts


HTH