Macros for selecting from dropdown

[msharma864512]

I am looking to write macros to select text from the dropdown.

I have provided the details in the attached spreadsheet.

 

[Chihiro]

Sub selectedScore_Type()

[C4] = ActiveSheet.Buttons(Application.Caller).Text
End Sub

Sub selectedSector()
[C5] = ActiveSheet.Buttons(Application.Caller).Text
End Sub

Assign code to each set.

 

[msharma864512]

Sub selectedScore_Type()

[C4] = ActiveSheet.Buttons(Application.Caller).Text
End Sub

Sub selectedSector()
[C5] = ActiveSheet.Buttons(Application.Caller).Text
End Sub

Assign code to each set.

Thank you very much Chihiro, it was very helpful

 

[msharma864512]

Is there a way, I can select multiple buttons at a time. For e.g. under region macros, is it possible to select two regions (Central and Northeast) or anyother combination at a time.