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

what is code to activate a combo box in control toolbox
 

.. but when the name goes into af16
it won't run all of the if and and statements that are linked to
what is entered into af16

It should work ok. But there could be extraneous leading, trailing or
in-between whitespaces, for example which is throwing things off in your
downstream formulas pointing to AF16.

Perhaps just try cleaning the names within the list fill range: AU822:AU846

Put in say, AV822: =TRIM(AU822)
Copy down to AV846
Then cut out AV822:AV846 and overwrite the names within AU822:AU846
with a paste special as values.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"pogo" wrote:
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