How to get selected item in Drop down, The Excel contains Macro enabled

Help
1

I have macro enabled excel sheet with different tab, in that sheet with few drop down with list of text. When i select the drop down text, it appears index value. Where all the values(Text) are available in different tab with hidden mode. i need to select it dynamically. how to get that selected item…

Can any one help me. Thanks in advance

2

I would like to help you, can you please replica the same in an empty excel and attach here.

3

is there only option to select from the drop down or you can enter the value and get the data.?

4

Business.xlsx (11.4 KB)

Please find the sheet. due to business restrictions cant share full sheet

5

Only drop down

6

sample file attached

7

Test.xaml (7.1 KB)
You can use this xaml file

8

Thanks for Reply. Here I don’t get any selected item result.