Listbox question

Hi,

Use instead Select Case, that one will do the trick.

Formula:

Select Case

Case ListBox1.Value = 0

Call b7



Case ListBox1.Value =1

Call b8



Case ListBox1.Value = 2

Call b9

End Case

My knowledge about VBA is not so great, this could work or maybe it has to be edited a little bit more.