Skip to Content
0
Former Member
Dec 17, 2010 at 02:19 AM

How to populate a list box linked to selection in combo box?

110 Views

Hi All,

I am a beginner in Xcelsius. I am having problem on how to populate a list box based on the selection on my combo box.

I have a combo box and a list box. The combo box value consist of Countries. Values are:

Singapore

Indonesia

Thailand

When I select, for i.e. Indonesia, I want to populate the list box with all the Postal Code of Indonesia. When I select Thailand, i want to do the same.

Can anyone shed some lights on how to achieve this?

My spreadsheet data is as follow

-


Country Postal Code

Singapore 680123

Singapore 680124

Singapore 680125

Indonesia 155123

Indonesia 155124

Indonesia 155125

Indonesia 155126

Thailand 333123

Many Thanks,

Harianto