close

I am having problems showing a database that I created. Every database
is named DB. I created a userform and I want the list box to show the
database from the active sheet. How do I write that formula in VB? If
someone could please help me it would be much appreciated

Sub SelectItemsActive()
UserForm1.ListBox1.RowSource = quot;=ActiveSheet!DBquot;
UserForm1.Show
End Sub

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()