ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dynamically Add Combo Boxes (https://www.excelbanter.com/excel-programming/339435-dynamically-add-combo-boxes.html)

AP

Dynamically Add Combo Boxes
 
Hello:
I woudl like to build a form that behaves in a manner that is similar to the
Excel Conditional Formatting Screen. By this I mean, that as the user selects
an option, an additional combo box appears for the next selection. Im not
sure if the best way to do this is to pre build the controls and hide them,
or to truly build on the fly since it is not know in advance how many
criteria options the user will need? Any suggestions?

Thanks

Dave Peterson

Dynamically Add Combo Boxes
 
Conditional formatting has a max of 3 conditions.

I'd pick a number never to exceed and hide those controls.

AP wrote:

Hello:
I woudl like to build a form that behaves in a manner that is similar to the
Excel Conditional Formatting Screen. By this I mean, that as the user selects
an option, an additional combo box appears for the next selection. Im not
sure if the best way to do this is to pre build the controls and hide them,
or to truly build on the fly since it is not know in advance how many
criteria options the user will need? Any suggestions?

Thanks


--

Dave Peterson


All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com