Hi,

I have a combobox. Which has 4 values
North, West, South, East.

In a macro I want to get other values based on the selection.
for example i have variables for flow.
It is named as Flow_N, Flow_W, Flow_S, Flow_E.

i want to assign the flow value to a temporary variable based on the selection.

i did like this before for ole objects. but i dont know how to do it for variables.
ActiveSheet.OLEObjects("Approach" & k).Object.Value


Can anyone help me?

Thanks