Yes, kind of....
Make sure the code window of the worksheet you want is open.
Click the drop down at the top left and select you combo box.
You will get the default event inserted for you, which _Change, I think.
So now click the top right drop down and select Click.

NickHK

"pogo" wrote in message
...
is the click in the upper right hand drop down menu in the section that
you
would view code, and im new at this what kind of code do i enter and how,
sorry so new but learning every day

"NickHK" wrote:

The comb box has a _Click which fires when you select one the values on
the
list.
You can run code from that event.

NickHK

"pogo" wrote in message
...
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.