Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all,
I am very new to the VBA programming language. I have managed to solve most of my problems by looking for answers here, on the Internet and in a nice little book called "Excel 2003 VBA". Background: I am planning to have a excel sheet that can display information based on a list located in another sheet (a database of sorts). So, the "database sheet" contains names,numbers and values and I plan to have a "display sheet" that will display values and calculations for one member of the database/list at a time. VBA involvment: I want to be able to press a button to open up a simple userform with a listbox. In the listbox I want to list the members of the database. When I click on any of the members I want the userform to close and that the values for that perticular member to be displayed in my "display sheet". Problem: Well, the excel part is easy enough but I really don't know where to start with the VBA. I have created a userfrom and I have added a listbox. Now how do I get the listbox to display the "members" from the database sheet? All the rest I'll worry about later.. :) I haven't found any article yet to help me so maybe anyone here knows where I should start to look for info? Or can you give a hint so I know where to start? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Listbox on Excel Userform | Excel Programming | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
Userform Listbox using an active sheet | Excel Discussion (Misc queries) | |||
get a list of sheet names onto a listbox on a form | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |