CODEWITHSUNDEEP
excelvba
afares
afares

Reputation: 11

0-based index Combobox in Excel

I am using Combobox Form control in Excel for my drop lists. I read on the net that the combobox is 0-based index. But when I use it, I find that it is 1-based index.

When I select the first element, it shows 1 in the linked cell and not zero.

Is there an easy way to make it 0-based index ? I want to display 0 when I select the first element and select the first element when i type 0 in the linked cell.

thanks,

Upvotes: 0

Views: 336

Answers (1)

aymhenry
aymhenry

Reputation: 91

  • link the combo box to set its output to cell A1 for example.
  • in cell B2 type =A1-1

Upvotes: 1

Related Questions