Combo box range change

's Computer Specifications

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

's Computer Specifications

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
>
>

's Computer Specifications

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

's Computer Specifications

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.

's Computer Specifications

You can also have a look here:

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.

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combo box contents doesn't change when filtering combo box is chan	Joe M.	Microsoft Access	2	17th Nov 2009 10:38 PM
Use a combo to change the data range for a chart?	WildlyHarry	Microsoft Excel Misc	1	27th Mar 2009 02:17 PM
How can change range to select active rows instead of :=Range("S10	ldiaz	Microsoft Excel Misc	7	29th Aug 2008 03:52 PM
Create/copy combo boxes in one range if condition is met in a different range	LB	Microsoft Excel Programming	4	30th Sep 2005 12:21 AM
How do I make one combo box change based on another combo box	=?Utf-8?B?TWFydHk=?=	Microsoft Access Forms	1	22nd Sep 2005 07:35 PM