Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Data into ListBox
Ok, ive tried everything i can think of but i just cant get it to
work, i want to load an array of data into a list box when a form opens. eg: Private Sub UserForm_initialize() With ListMonth ..AddItem "July" ..AddItem "August" ..AddItem "September" ..AddItem "October" ..AddItem "Novemebr" ..AddItem "December" ..AddItem "Janurary" ..AddItem "February" ..AddItem "March" ..AddItem "April" ..AddItem "May" ..AddItem "June" End With End Sub but this doesnt seem to work, i can hook the sub up to a button and make it work, but i just want it to happen on opening the form? how do i do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Data into ListBox
I find it easer to just list the items somewhere out of the road in a
column, and use the : RowSource= Sheet1!A1:A12 to populate the list. else check to make sure "LISTMONTH" is the correct List name Corey.... wrote in message ups.com... Ok, ive tried everything i can think of but i just cant get it to work, i want to load an array of data into a list box when a form opens. eg: Private Sub UserForm_initialize() With ListMonth '<==== Listbox1 ?? .AddItem "July" .AddItem "August" .AddItem "September" .AddItem "October" .AddItem "Novemebr" .AddItem "December" .AddItem "Janurary" .AddItem "February" .AddItem "March" .AddItem "April" .AddItem "May" .AddItem "June" End With End Sub but this doesnt seem to work, i can hook the sub up to a button and make it work, but i just want it to happen on opening the form? how do i do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Data into ListBox
Works for me.
But you may want to get the VBE to generate the event signatures for you instead of typing your self, to avoid errors. Select the component from the left-hand combo box in the Userform's code window. Then select the event from the right-hand combo box. In this case "UserForm_initialize" is recognised as "UserForm_Initialize", so it is OK. NickHK wrote in message ups.com... Ok, ive tried everything i can think of but i just cant get it to work, i want to load an array of data into a list box when a form opens. eg: Private Sub UserForm_initialize() With ListMonth .AddItem "July" .AddItem "August" .AddItem "September" .AddItem "October" .AddItem "Novemebr" .AddItem "December" .AddItem "Janurary" .AddItem "February" .AddItem "March" .AddItem "April" .AddItem "May" .AddItem "June" End With End Sub but this doesnt seem to work, i can hook the sub up to a button and make it work, but i just want it to happen on opening the form? how do i do this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Data into ListBox
On Feb 1, 1:32 pm, "NickHK" wrote:
Works for me. But you may want to get the VBE to generate the event signatures for you instead of typing your self, to avoid errors. Select the component from the left-hand combo box in the Userform's code window. Then select the event from the right-hand combo box. In this case "UserForm_initialize" is recognised as "UserForm_Initialize", so it is OK. NickHK wrote in message ups.com... Ok, ive tried everything i can think of but i just cant get it to work, i want to load an array of data into a list box when a form opens. eg: Private Sub UserForm_initialize() With ListMonth .AddItem "July" .AddItem "August" .AddItem "September" .AddItem "October" .AddItem "Novemebr" .AddItem "December" .AddItem "Janurary" .AddItem "February" .AddItem "March" .AddItem "April" .AddItem "May" .AddItem "June" End With End Sub but this doesnt seem to work, i can hook the sub up to a button and make it work, but i just want it to happen on opening the form? how do i do this?- Hide quoted text - - Show quoted text - Sweet! that did the trick, thanks alot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loading data into a listbox faster | Excel Programming | |||
Loading data into Excel file from Data table. | Excel Programming | |||
loading data from access in vba | New Users to Excel | |||
Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions | |||
Loading Data from File ~~!!~~ | Excel Programming |