Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box data
I noticed that when you placed a listbox on wrksht you
can use a data list for your ListFIllRange. But when you want a listbox on a userform...there isnt a ListFillRange. Does this mena i will have to do a ADDITEM on a initialize procdure b4 it opens? Can i attached alist or reference one?? My data list is about 60 rows long?? Did i miss another way somewhere?? any help thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box data
Use the RowSource property, enter the range that contains your list..
HTH, Greg "mike" wrote in message ... I noticed that when you placed a listbox on wrksht you can use a data list for your ListFIllRange. But when you want a listbox on a userform...there isnt a ListFillRange. Does this mena i will have to do a ADDITEM on a initialize procdure b4 it opens? Can i attached alist or reference one?? My data list is about 60 rows long?? Did i miss another way somewhere?? any help thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box data
In the userform it is called RowSource. The actual property is provided by
the container - (oleObject on worksheet, control on userform) thus a difference. So look for the RowSource propert and set it to Sheet1!A1:B20 for example. -- Regards, Tom Oglivy "mike" wrote in message ... I noticed that when you placed a listbox on wrksht you can use a data list for your ListFIllRange. But when you want a listbox on a userform...there isnt a ListFillRange. Does this mena i will have to do a ADDITEM on a initialize procdure b4 it opens? Can i attached alist or reference one?? My data list is about 60 rows long?? Did i miss another way somewhere?? any help thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box data
Thank You!! both...( sigh) fingers are tired
today....brain is fried. -----Original Message----- In the userform it is called RowSource. The actual property is provided by the container - (oleObject on worksheet, control on userform) thus a difference. So look for the RowSource propert and set it to Sheet1!A1:B20 for example. -- Regards, Tom Oglivy "mike" wrote in message ... I noticed that when you placed a listbox on wrksht you can use a data list for your ListFIllRange. But when you want a listbox on a userform...there isnt a ListFillRange. Does this mena i will have to do a ADDITEM on a initialize procdure b4 it opens? Can i attached alist or reference one?? My data list is about 60 rows long?? Did i miss another way somewhere?? any help thanks! . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box data
Okay , another question... you know how you can (once you
have highligted in the list of the list box?? you can just type the frst letter of your choice and it goes to it?? how do i modify code to where you can repeat that letter key tillyou get thru a list of "t" 's tillyour choice comes up? -----Original Message----- In the userform it is called RowSource. The actual property is provided by the container - (oleObject on worksheet, control on userform) thus a difference. So look for the RowSource propert and set it to Sheet1!A1:B20 for example. -- Regards, Tom Oglivy "mike" wrote in message ... I noticed that when you placed a listbox on wrksht you can use a data list for your ListFIllRange. But when you want a listbox on a userform...there isnt a ListFillRange. Does this mena i will have to do a ADDITEM on a initialize procdure b4 it opens? Can i attached alist or reference one?? My data list is about 60 rows long?? Did i miss another way somewhere?? any help thanks! . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box data
From help on the matchentry property of the combobox/listbox
constant: fmMatchEntryFirstLetter value: 0 Explanation: Basic matching. The control searches for the next entry that starts with the character entered. Repeatedly typing the same letter cycles through all entries beginning with that letter. Please see the help on this however for a fuller explanation and other considerations. -- Regards, Tom Ogilvy "mike" wrote in message ... Okay , another question... you know how you can (once you have highligted in the list of the list box?? you can just type the frst letter of your choice and it goes to it?? how do i modify code to where you can repeat that letter key tillyou get thru a list of "t" 's tillyour choice comes up? -----Original Message----- In the userform it is called RowSource. The actual property is provided by the container - (oleObject on worksheet, control on userform) thus a difference. So look for the RowSource propert and set it to Sheet1!A1:B20 for example. -- Regards, Tom Oglivy "mike" wrote in message ... I noticed that when you placed a listbox on wrksht you can use a data list for your ListFIllRange. But when you want a listbox on a userform...there isnt a ListFillRange. Does this mena i will have to do a ADDITEM on a initialize procdure b4 it opens? Can i attached alist or reference one?? My data list is about 60 rows long?? Did i miss another way somewhere?? any help thanks! . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box data
tom , silly me , i found once i have studied each
property in the property box of the control. However..I have one more for the day....Once i have created the form..How do I launch the form? what module do i oput the the show code in? I would liek the form to show up when that workbook is opened and then closed when it is closed. is it possible to attach the formto a icon on the worksheet and let it be clicked to show the form?? -----Original Message----- From help on the matchentry property of the combobox/listbox constant: fmMatchEntryFirstLetter value: 0 Explanation: Basic matching. The control searches for the next entry that starts with the character entered. Repeatedly typing the same letter cycles through all entries beginning with that letter. Please see the help on this however for a fuller explanation and other considerations. -- Regards, Tom Ogilvy "mike" wrote in message ... Okay , another question... you know how you can (once you have highligted in the list of the list box?? you can just type the frst letter of your choice and it goes to it?? how do i modify code to where you can repeat that letter key tillyou get thru a list of "t" 's tillyour choice comes up? -----Original Message----- In the userform it is called RowSource. The actual property is provided by the container - (oleObject on worksheet, control on userform) thus a difference. So look for the RowSource propert and set it to Sheet1!A1:B20 for example. -- Regards, Tom Oglivy "mike" wrote in message ... I noticed that when you placed a listbox on wrksht you can use a data list for your ListFIllRange. But when you want a listbox on a userform...there isnt a ListFillRange. Does this mena i will have to do a ADDITEM on a initialize procdure b4 it opens? Can i attached alist or reference one?? My data list is about 60 rows long?? Did i miss another way somewhere?? any help thanks! . . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box data
if you want it displayed when the workbook is opened, then use the
workbook_Open event. Also see the BeforeClose Event see Chip Pearson's page on Events http://www.cpearson.com/excel/events.htm for a button from the forms toolbar, create a macro in a standard module Sub Btn_Click() userform1.show End Sub then assign it to your button. if you mean on a toolbar, then do tools=customize, then create a new toolbar or add a button to an existing toolbar and assign your macro (btn_click) to that. If you just want to run the macro, then run btn_click If from a commandbar button on the worksheet, drag the button onto the worksheet and double click on it. In the resulting procedure, put in code like Private Sub Commandbutton1_Click() userform1.show End Sub -- Regards, Tom Ogilvy "mike" wrote in message ... tom , silly me , i found once i have studied each property in the property box of the control. However..I have one more for the day....Once i have created the form..How do I launch the form? what module do i oput the the show code in? I would liek the form to show up when that workbook is opened and then closed when it is closed. is it possible to attach the formto a icon on the worksheet and let it be clicked to show the form?? -----Original Message----- From help on the matchentry property of the combobox/listbox constant: fmMatchEntryFirstLetter value: 0 Explanation: Basic matching. The control searches for the next entry that starts with the character entered. Repeatedly typing the same letter cycles through all entries beginning with that letter. Please see the help on this however for a fuller explanation and other considerations. -- Regards, Tom Ogilvy "mike" wrote in message ... Okay , another question... you know how you can (once you have highligted in the list of the list box?? you can just type the frst letter of your choice and it goes to it?? how do i modify code to where you can repeat that letter key tillyou get thru a list of "t" 's tillyour choice comes up? -----Original Message----- In the userform it is called RowSource. The actual property is provided by the container - (oleObject on worksheet, control on userform) thus a difference. So look for the RowSource propert and set it to Sheet1!A1:B20 for example. -- Regards, Tom Oglivy "mike" wrote in message ... I noticed that when you placed a listbox on wrksht you can use a data list for your ListFIllRange. But when you want a listbox on a userform...there isnt a ListFillRange. Does this mena i will have to do a ADDITEM on a initialize procdure b4 it opens? Can i attached alist or reference one?? My data list is about 60 rows long?? Did i miss another way somewhere?? any help thanks! . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003. Data/Validation/Settings - Allow/List: sizing list? | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
How to view a list of data based on another list of data | Excel Discussion (Misc queries) | |||
converting vertical data list to horizontal data list | Excel Worksheet Functions |