1

this is definitely a beginners question.

I would like to know how can I show in my userform only 1 value.

I have tried following but it wont go through - it needs at least 2 values.

ListBox.List = Application.Worksheets("Můj_Ranking").Range("Y5").Value
R3uK
  • 14,417
  • 7
  • 43
  • 77
HeadOverFeet
  • 768
  • 6
  • 13
  • 33

1 Answers1

1

Just use .AddItem :

ListBox.AddItem Application.Worksheets("Můj_Ranking").Range("Y5").Value
R3uK
  • 14,417
  • 7
  • 43
  • 77
  • Sorry,I have left out that Rank is a List box. I need to sho it in my user form, but I dont know how. – HeadOverFeet Nov 26 '15 at 12:22
  • Thank you very much!! Dont you know whether there is a possibility to reduce scrollbar? It always shows even there is no more data and it is not necessary to have it there. – HeadOverFeet Nov 26 '15 at 12:33
  • Okey, there is no need :) I see it here: http://stackoverflow.com/questions/5638129/remove-the-scroll-bar-on-a-list-box – HeadOverFeet Nov 26 '15 at 12:34