Option button & droplist

[ammo4814]

Hi everybody ,
Can I ask if some one can help me with a way to link the option button with droplist ( two radio buttons ) , I mean when I click on the option button 1 give me list of customers and when click on option button 2 give me list of another customers .

Thanks

 

[Hui]

Ammo

Firstly, Welcome to the Chandoo.org Forums

Can you please post a sample file here with what data you have and how you want to use it

 

[ammo4814]

Dear ,

attached example may help you , actully i tried to upload excel file but i couldnot

Thanks for your help

 

[Khalid NGO]

Hi,
See if this is okay.

Regards,

 

[ammo4814]

Dear Kahild ,

it is ok , but i have on probelem that when i select from list box ( click on customer inside ) values changes .

could you please advise and help .

 

[Khalid NGO]

Dear Kahild ,

it is ok , but i have on probelem that when i select from list box ( click on customer inside ) values changes .

could you please advise and help .

Oh i did linked all items with one cell,

Right click on list box > Format Control > Control >
Change the cell link to other cell.

Same procedure for Drop Down list.

Regards,

 

[ammo4814]

Thanks Khalid , it is work ok

 

[Khalid NGO]

Thanks Khalid , it is work ok

glad you've done it.
Thanks for the feedback,

and you are welcome.
keep visiting.

Regards,