Hello,

However if the dynamic range is bases on a horizontal range :

a b c

Instead of usuel vertical range

a

b

c

This is not working and only 'a' is shown in the excel combo box(type =from control, not active X control)... ?

In my case i have dynamic horizontal range (so i can have a b c or a b c d or a b c d e, etc...), so How can i fil in a combobox based on a dynamic horizontal range ? Currently i use an range name calle 'dynamic' based on the offset function. And it représents the right range. Ok. But the combo box which use the range as row source, shows only the first elem 'a'

One solution is to transpose the horizontal range in a vertical range, but i don t manage to do it since my range is dynamic and can contains a variable nimber of values.

Anyone as an idea ? Thank you