How to create multiple columns, in List

[JFogh]

Hi

I have made a List in a Dialogsheet 5.0 via the gui interface.
When I choose the inputrange to be e.g. $A$1:$C$3 its still only making one column with the values $A$1:$A$3. Anyone who can help me, how to make more columns (in this example 3)

Kind regards
Jens Fogh

 

[Sektor]

Look here

 

[JFogh]

The suggested solution:
"
In Listbox properties, set:
1. ColumnCount = 7
2. ColumnHeads = True
3. RowSource = Data range EXCLUDING headers in format "=Sheet1!D15:K22"
"

Do you know a solution, where you, use the gui? I can't find any place to insert the values?
If not, when I try to write this in a macro, it gives a syntax error at the last line.


(The only values I can find via the GUI are, cell chain and input range)

 

[JFogh]

I how now found the fields, but this is for a Userform, not a Dialog Sheet 5.0....Anybody who knows if it is possible to make a list with multiple rows in a Dialog Sheet 5.0?