m,

I think that the sheet name should be the name of the sheet
that the combobox is on.
I also think that the code belongs in the code module behind
the sheet (right-click the sheet tab and select "view code").

Jim Cone

wrote in message
oups.com
Jim,
From the control toolbox, yes.
I edited the code a bit (see below) and now nothing at all is happening
when I select something from the dropdown menu.... what do you think?

Sub ComboBox6()

If Sheets("Competencies").ComboBox6.Value = "Main Menu" Then Call
DisplayMenu
If Sheets("Competencies").ComboBox6.Value = "Goals" Then Call
DisplayGoals
If Sheets("Competencies").ComboBox6.Value = "Development Plan" Then
Call DisplayDevPlan
If Sheets("Competencies").ComboBox6.Value = "Mid-Year" Then Call
DisplayMidYear
If Sheets("Competencies").ComboBox6.Value = "Self-Evaluation" Then Call
DisplaySelfEval
If Sheets("Competencies").ComboBox6.Value = "Functional Manager" Then
Call DisplayFunctionalMgr
If Sheets("Competencies").ComboBox6.Value = "Manager" Then Call
DisplayManager

End Sub