<div>
curVAL= ActiveSheet.Shapes(&quot;cboFig<wbr />ht1&quot;).Valu<wbr />e
</div>


curVAL= ActiveSheet.Shapes("cboFight1").Value

<div>
ActiveSheet.Shapes(&quot;cboFig<wbr />ht1&quot;).Valu<wbr />e<br />
<br />
still gives me that error
</div>


ActiveSheet.Shapes("cboFight1").Value

still gives me that error

<div>
curVal = ActiveSheet.DropDowns(Appl<wbr />ication.Ca<wbr />ller).List<wbr />(ActiveShe<wbr />et.DropDow<wbr />ns(Applica<wbr />tion.Calle<wbr />r).Value)<br />
<br />
WORKED!!!!<br />
<br />
That seems way overly complicated though.
</div>


curVal = ActiveSheet.DropDowns(Application.Caller).List(ActiveSheet.DropDowns(Application.Caller).Value)

WORKED!!!!

That seems way overly complicated though.

<div>
<div class="content wysiwyg-content">
I am trying to access a combobox value through vba. &nbsp;However my code is not working.<br />
<br />
The code is in a module so I figured I'd have to specify a sheet and I'd be okay.<br />
<br />
Sub cboFight1_Change()<br />
&nbsp; &nbsp; Dim curVal As String<br />
&nbsp; &nbsp; curVal = ActiveSheet.cboFight1.Valu<wbr />e<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; MsgBox curVal<br />
End Sub<br />
<br />
I get an object doesn't support that property or method.<br />
<br />
Any ideas,<br />
JOe K.
</div>
</div>


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.

reference comobobox thru vba in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.