Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically assign items to a list box
Hi,
Is there a way to automatically add items to a list box and then programatically act according to the item selected by the user ? This is the scenario: I have a spreadsheet that keeps statistics of basketball games. Each time the assistant to the coach needs to add the stats of a new game, he/she clicks on a button (which is linked to a macro) and a new blank template is appended to the end of the sheet. Then he/she fills the recently added template and some calculations are done. Before exiting, the spreadsheet is saved. I've been able to implement this by means of a couple of macros and a bit of user-interface design. So far, so good. The problem is that as long as the spreadsheet grows, it is more and more time-consuming to locate the stats of any given game, requiring many page-up's and page-down's and/or Edit | Search, so I thought that a feature to automatically "jump" to the stats of the game of choice may come handy. For this task, I thought of adding a list box (which should be linked to a macro) whose items must be picked from -for example- the first cell of the first row of every game, and then, according to the item or "game" selected by the user, jump to that stat. That simple. I thought of creating an autoexecutable macro that could -for example- run when the .XLS file is opened and create the list box on the fly, however, although I can programatically parse the whole sheet and read the content of the cells that identify each game, I don't know how to feed the content of these cells to the list box. I have no doubts it has to be possible to implement this. I'll highly appreciate if someone points me in the right direction to achieve my goal. Thank you, Fernando Ronci E-mail: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign a formula to count items in a column if they are within cor | Excel Worksheet Functions | |||
Dynamically changing the size of a list | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Dynamically assign items to a list box | Excel Programming | |||
Assign macros to dynamically created form elements | Excel Programming |