Horizontal values in a listbox

[BigJ]

Hi all

I want to use a listbox to allow my users to select one of 5 options. Easy enough, but I want the options to display horizontally rather than vertically, because of the design of the spreadsheet.

Can this be done? Or does anyone have an alternative suggestion?

Thanks

BigJ

 

[Andrew Poulsom]

It sound like you need a horizontal line of OptionButtons with the same GroupName.

 

[Lewiy]

ListBoxes will only display values vertically in a column. If you only have 5 options which are always the same, you could use some option buttons instead.

 

[BigJ]

Thanks chaps. Andrew's GroupName suggestion has turned the trick!