Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form
I am still having trouble loading this form. It is nothing
to do with the name as i cannot even load it from the Visual Basic Menu with the play button. I have pasted the code for Initialise event if this helps. I get the following message 'Object Required' TIA Private Sub UserForm_Initialize() Dim ListItems As Variant, i As Integer Dim SourceWB As Workbook With Form_Suppliers.ListBox1 .Clear Set SourceSh = Worksheets("Email_Control") ListItems = SourceSh.Range("A1:A" & Range ("A65536").End(xlUp).Row).Value Application.ScreenUpdating = True ListItems = Application.WorksheetFunction.Transpose (ListItems) For i = 1 To UBound(ListItems) .AddItem ListItems(i) Next i .ListIndex = -1 End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form
I don't see anything obviously wrong, but you could simplify it
Private Sub UserForm_Initialize() Dim rng as Range With Worksheets("Email_Control") set rng = .Range(.Cells(1,1),.Cells(rows.count,1).End(xlup)) End With With me.ListBox1 .Clear .list = rng.Value End With -- Regards, Tom Ogilvy "Edgar Thoemmes" wrote in message ... I am still having trouble loading this form. It is nothing to do with the name as i cannot even load it from the Visual Basic Menu with the play button. I have pasted the code for Initialise event if this helps. I get the following message 'Object Required' TIA Private Sub UserForm_Initialize() Dim ListItems As Variant, i As Integer Dim SourceWB As Workbook With Form_Suppliers.ListBox1 .Clear Set SourceSh = Worksheets("Email_Control") ListItems = SourceSh.Range("A1:A" & Range ("A65536").End(xlUp).Row).Value Application.ScreenUpdating = True ListItems = Application.WorksheetFunction.Transpose (ListItems) For i = 1 To UBound(ListItems) .AddItem ListItems(i) Next i .ListIndex = -1 End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula (off form) that completes form data based on a result | Excel Worksheet Functions | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions |