Good Evening,
I am trying to create a listbox that appears on a userform when i press a button.
I have created a userform "LorraineS" with a listbox on it "fillorraine" I am using the following code to load the information as the info and userforms are in 2 different files. ( These will change on a regular basis as the info it is pulling in gives running totals on open enquiries )
It tries to run but says missing "Run-time error '424' Object required"
Hopefully this is the last issue i will have.
Many Thanks
I am trying to create a listbox that appears on a userform when i press a button.
I have created a userform "LorraineS" with a listbox on it "fillorraine" I am using the following code to load the information as the info and userforms are in 2 different files. ( These will change on a regular basis as the info it is pulling in gives running totals on open enquiries )
It tries to run but says missing "Run-time error '424' Object required"
Hopefully this is the last issue i will have.
Many Thanks
Rich (BB code):
Private Sub UserForm_Initialize()
Workbooks.Open Filename:="C:\Users\MAZZA\Documents\Gavin\Car Park\FYVData.xls" 'Home
'Workbooks.Open Filename:="\\W2K6082\COMMON\SHARED\Gavin Mazza\Car Park\FYVData.xls"
With Stats.Range("B1:I14")
ListBox1.ColumnCount = .Columns.Count
ListBox1.List = .Value
End With
