Developer Ribbon - Form Controls

[mikeymay]

I have some controls embedded in a worksheet (Form Controls and not ActiveX controls) and I need to execute some macros when they are changed.

I am struggling to find the code I need to implement this. I have tried

Range("Analysis_Category") = ActiveSheet.Shapes("cbox_Category").Value

but this doesn't seem to work.


Thanks

 

[Jaafar Tribak]

What do you mean by "when they are changed" ?

 

[MickG]

Perhaps :-

'If it is a ListBox or Combobox then try this :-
With ActiveSheet.Shapes("cbox_Category").ControlFormat
    Range("Analysis_Category") = .List(.ListIndex)
End With
'Or maybe :-
Range("Analysis_Category") = ActiveSheet.Shapes("cbox_Category").ControlFormat.Value

 

[mikeymay]

Thanks MikeG

Managed to pick that up from somewhere after a bit more trawling.