Was wondering if there is a similar way (as below) or a different way to grab the "Macro name:" value of the macro assigned to an old Form combobox. Thank you very much.
Had similar question with ID 26805164 where I was looking to grab the "Input range:" and "Cell link:" values of an old Form combobox. That question was answered with the following code:
Dim S As Shape
For Each S In ActiveSheet.Shapes
If S.Type = msoFormControl Then
If S.FormControlType = xlDropDown Then
MsgBox Selection.Name & vbCrLf & Selection.ListFillRange & vbCrLf & Selection.LinkedCell