Using info from dropdownlists in macros

Hi,

In Data → Validity i changed the cell A1 to the type List and wrote the options that can be selected.

Now on a macro i have to do some calculations depending on the option selected in the list by the user, but when i access the data of the cell it always returns the first option, no matter which one is selected

Can someone help me?

Thanks,
Bruno