VBA如何在用户表单中显示1个单元格的值

this is definitely a beginners question.

这绝对是一个初学者的问题。

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

我想知道如何在userform中只显示一个值。

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

我已经尝试了跟随，但它不能通过-它需要至少2个值。

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

1 个解决方案

#1

Just use .AddItem :

只使用.AddItem:

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