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

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

software

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