CODEWITHSUNDEEP
vbaexceluserform
HeadOverFeet
HeadOverFeet

Reputation: 788

VBA how to show 1 value from 1 cell in USER form

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

Upvotes: 1

Views: 110

Answers (1)

R3uK
R3uK

Reputation: 14537

Just use .AddItem :

ListBox.AddItem Application.Worksheets("Můj_Ranking").Range("Y5").Value

Upvotes: 1

Related Questions