0

As a source of data for my ListBox, I have specifed named range (RowSource - Dimension). However, instead of actual values in a ListBox, I want to have custom display values.

example

I trying to change Value in Appearance tab but I get an error "Could not set the Value property. Invalid property value"

How can I make "60" be displayed as "High"?

Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
timetravelprimer
  • 111
  • 9
  • Possible duplicate of [Adding items in a Listbox with multiple columns](https://stackoverflow.com/questions/6973287/adding-items-in-a-listbox-with-multiple-columns) – braX Sep 18 '19 at 08:33
  • I don't think so. I don't want to add items to listbox. I simply want to change display value. – timetravelprimer Sep 18 '19 at 08:38
  • 1
    It doesnt work like that. you need 2 columns, and then you set the width of one column to zero to hide it. See the `ColumnWidths` property? try setting it to `0px; 100px" – braX Sep 18 '19 at 08:39

0 Answers0