troelsi
03-19-2009, 07:30 AM
Hello
I'm using the new version of Excel and I have made some sort of interface that contains dropdown lists and check boxes. However, I don't know how to connect the interface with the VBA code.
I would like to store the choices selected with the drop-down box in a variabel, so I can use the information entered in my vba.code. Also i would like to store in a variabel if the checkboxes are cheked or not.
I suppose there is a rather simepl way of dealing with this that I just don't know of.
Please help.
Regards
Troels
I'm using the new version of Excel and I have made some sort of interface that contains dropdown lists and check boxes. However, I don't know how to connect the interface with the VBA code.
I would like to store the choices selected with the drop-down box in a variabel, so I can use the information entered in my vba.code. Also i would like to store in a variabel if the checkboxes are cheked or not.
I suppose there is a rather simepl way of dealing with this that I just don't know of.
Please help.
Regards
Troels