what is code to activate a combo box in control toolbox
hello everyone, i am using a combo box from controls toolbox. in the
properties menu of the combo box i have the list fill range set to a list
created in au822:au846. the linked cell is af16. i put the combo box in ag16.
i want someone to be able to select a name from the combo box drop down list
and have that name enter into af16. that part works but when the name goes
into af16 it wont run all of the if and and statements that are linked to
what is enetered into af16. I fi dont have a drop down box and manuallytype
the name into af16 all of the statements or functions work great. How do i
get the drop down item selected to work when it enters into af16? like i said
i got the name to enter into af16 but it wont run any of the othe functions.
please help me
thanks
|