reference comobobox thru vba in Excel

I am trying to access a combobox value through vba.  However my code is not working.

The code is in a module so I figured I'd have to specify a sheet and I'd be okay.

Sub cboFight1_Change()
    Dim curVal As String
    curVal = ActiveSheet.cboFight1.Value
   
    MsgBox curVal
End Sub

I get an object doesn't support that property or method.

Any ideas,
JOe K.
ClaudeWalkerAsked:
Who is Participating?
 
chwong67Connect With a Mentor Commented:
curVal = ActiveSheet.DropDowns(Application.Caller).List(ActiveSheet.DropDowns(Application.Caller).Value)
0
 
hitsdoshi1Commented:
curVAL= ActiveSheet.Shapes("cboFight1").Value
0
 
ClaudeWalkerAuthor Commented:
ActiveSheet.Shapes("cboFight1").Value

still gives me that error
0
 
ClaudeWalkerAuthor Commented:
curVal = ActiveSheet.DropDowns(Application.Caller).List(ActiveSheet.DropDowns(Application.Caller).Value)

WORKED!!!!

That seems way overly complicated though.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.