Hi All,

I have a workbook with 2 sheets. On sheet 1 I have two lists:

List1:
Column A Column B
ProjectID ProjectName

List2:
Column D Column E Column F
ProjectID SubProjectID SubProjectName

On sheet 2, I have 2 combo boxes. what I want to do is fill the first
combobox with the contents of list 1. the second combobox will be filled
based on the selection in the first combobox (ProjectID).

Can someone provide me with a few hints or code snippets? I think I'm
looking for code to go into the combobox1 change event.

TIA
Lee

Take a look at http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

"lgbjr" wrote in message
...
Hi All,

I have a workbook with 2 sheets. On sheet 1 I have two lists:

List1:
Column A Column B
ProjectID ProjectName

List2:
Column D Column E Column F
ProjectID SubProjectID SubProjectName

On sheet 2, I have 2 combo boxes. what I want to do is fill the first
combobox with the contents of list 1. the second combobox will be filled
based on the selection in the first combobox (ProjectID).

Can someone provide me with a few hints or code snippets? I think I'm
looking for code to go into the combobox1 change event.

TIA
Lee

Hi Bob,

Thanks for the link. And I'm sure the site probably has exactly what I need.
Unfortunately, I'm cyrrently living in China, and apparently the DNS server
that China Telecom uses can not find the site. I've had this issue before
with sites that I thought would be in all DNS servers. I also can't get to
Geocities for the UDQServices download.

Anyway, if you know of some other helpful links, please let me know.

regards,
Lee


"Bob Phillips" wrote in message
...
Take a look at http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

"lgbjr" wrote in message
...
Hi All,

I have a workbook with 2 sheets. On sheet 1 I have two lists:

List1:
Column A Column B
ProjectID ProjectName

List2:
Column D Column E Column F
ProjectID SubProjectID SubProjectName

On sheet 2, I have 2 combo boxes. what I want to do is fill the first
combobox with the contents of list 1. the second combobox will be filled
based on the selection in the first combobox (ProjectID).

Can someone provide me with a few hints or code snippets? I think I'm
looking for code to go into the combobox1 change event.

TIA
Lee

I can send you the page and a download if you give me your email addy

--
HTH

Bob Phillips

"lgbjr" wrote in message
...
Hi Bob,

Thanks for the link. And I'm sure the site probably has exactly what I
need.
Unfortunately, I'm cyrrently living in China, and apparently the DNS
server
that China Telecom uses can not find the site. I've had this issue before
with sites that I thought would be in all DNS servers. I also can't get to
Geocities for the UDQServices download.

Anyway, if you know of some other helpful links, please let me know.

regards,
Lee


"Bob Phillips" wrote in message
...
Take a look at http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

"lgbjr" wrote in message
...
Hi All,

I have a workbook with 2 sheets. On sheet 1 I have two lists:

List1:
Column A Column B
ProjectID ProjectName

List2:
Column D Column E Column F
ProjectID SubProjectID SubProjectName

On sheet 2, I have 2 combo boxes. what I want to do is fill the first
combobox with the contents of list 1. the second combobox will be
filled
based on the selection in the first combobox (ProjectID).

Can someone provide me with a few hints or code snippets? I think I'm
looking for code to go into the combobox1 change event.

TIA
Lee

Thanks Bob,

Please use

Regards,
Lee

"Bob Phillips" wrote in message
...
I can send you the page and a download if you give me your email addy

--
HTH

Bob Phillips

"lgbjr" wrote in message
...
Hi Bob,

Thanks for the link. And I'm sure the site probably has exactly what I
need.
Unfortunately, I'm cyrrently living in China, and apparently the DNS
server
that China Telecom uses can not find the site. I've had this issue before
with sites that I thought would be in all DNS servers. I also can't get
to
Geocities for the UDQServices download.

Anyway, if you know of some other helpful links, please let me know.

regards,
Lee


"Bob Phillips" wrote in message
...
Take a look at http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

"lgbjr" wrote in message
...
Hi All,

I have a workbook with 2 sheets. On sheet 1 I have two lists:

List1:
Column A Column B
ProjectID ProjectName

List2:
Column D Column E Column F
ProjectID SubProjectID SubProjectName

On sheet 2, I have 2 combo boxes. what I want to do is fill the first
combobox with the contents of list 1. the second combobox will be
filled
based on the selection in the first combobox (ProjectID).

Can someone provide me with a few hints or code snippets? I think I'm
looking for code to go into the combobox1 change event.

TIA
Lee

Hi Lee,

I was reviewing the issue thread. How is everything going now? If there is
any question, please feel free to post here.

Thanks very much for participating the community.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
-http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.as
p&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.

ÄãºÃ,

Well, unfortunately I am still unable to gain access to the xldynamic site,
which I understand has excellent content, and specifically content related
to my original post.

Not related to the original post, I have sent email to the xldynamic
webmaster (no response yet), and have tried various techniques to gain
access to the site (such as changing DNS servrs, adding a (free) proxy
server, using the IP address, rather than the name in IE, etc.). I've also
asked several colleagues in different cities and on different networks in
china to try to access the site. They all have the same result. no luck. I
don't understand why a site like xldynamic would be blocked in China.

Back to the original post, I really don't have an answer yet.

Best Regards,
Lee (Àî»ÊÉÐ)

"Yan-Hong Huang[MSFT]" wrote in message
...
Hi Lee,

I was reviewing the issue thread. How is everything going now? If there is
any question, please feel free to post here.

Thanks very much for participating the community.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
-http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.as
p&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no
rights.

Hi

I think it has nothing to do with the .NET Framework 2.0.
But I think you may try to create a new workbook and copy the code and data
into the new workbook to see if that works.
BTW: based on my test, the code will run on my side.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Lee (Àî),

Yes, please test as Peter mentioned. This problem seems like machine
specific. The code runs fine on Peter's machine. If you have any more
concerns, please feel free to reply here.

Thanks very much. :)

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
-http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.as
p&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.