Controling the list in a combo box
I'm trying to create a combo box where the list will vary
based upon a state that is chosen. Currently, I have a column setup as my list that will show a blank line for an invalid selection. However, this means I have 100+ blanks lines in my dropdown list. I want to get rid of the blank lines and have tried checking the ignore blanks box in the validation screen. Ay help would be appreciated. |
Controling the list in a combo box
What triggers the state selection? Is it another combobox?
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Bob" wrote in message ... I'm trying to create a combo box where the list will vary based upon a state that is chosen. Currently, I have a column setup as my list that will show a blank line for an invalid selection. However, this means I have 100+ blanks lines in my dropdown list. I want to get rid of the blank lines and have tried checking the ignore blanks box in the validation screen. Ay help would be appreciated. |
Controling the list in a combo box
Yes. It is another combobox.
-----Original Message----- What triggers the state selection? Is it another combobox? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Bob" wrote in message ... I'm trying to create a combo box where the list will vary based upon a state that is chosen. Currently, I have a column setup as my list that will show a blank line for an invalid selection. However, this means I have 100+ blanks lines in my dropdown list. I want to get rid of the blank lines and have tried checking the ignore blanks box in the validation screen. Ay help would be appreciated. . |
Controling the list in a combo box
I have a workbook sample if you want it. Mail me your email address.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Bob" wrote in message ... Yes. It is another combobox. -----Original Message----- What triggers the state selection? Is it another combobox? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Bob" wrote in message ... I'm trying to create a combo box where the list will vary based upon a state that is chosen. Currently, I have a column setup as my list that will show a blank line for an invalid selection. However, this means I have 100+ blanks lines in my dropdown list. I want to get rid of the blank lines and have tried checking the ignore blanks box in the validation screen. Ay help would be appreciated. . |
All times are GMT +1. The time now is 01:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com