please someone, i have been learning excel and working on this for months and
months. i am so frustrated.!!!!! My problem is this. in my excel sheet, i
have cell af16 control many different functions depending on what a person
would type into cell af16. people cant spell right(including myself) so
therefore i am trying to use a combo box from the control toolbar. I have
tried the forms combo box and data validation and the font is too small and
it doesnt look right. My idea is to choose from a list that i created in
cells au822:au846( example of list =m,inl,hol,office etc) each of these words
when placed into cell af16 activates functions which control the calculations
on the rest of the sheet. I have created the combol box and the list comes up
beautifully(list fill), and the cell linked is af16 which DOES take the word
from the drop down list and populates cell af16 with that word. The problem
is thats all it does I cant get the word to activate the functions as if I
were to actually type the word into af16( which makes it work). I know its
code and am stuck, if someone can help with this code I will dedicate so much
time to learning excel and then return the help on this forum.