Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
User Form
I am using winxp pro and msoffice 2003
I have never done a user form in excel and am not sure how to proceed. This is what I want to do: Make a user form with the alphabet across the top of the form, each letter of the alphabet links to a listing on the form, such as: If I click on "C", I go to the portion of the form where my "C" customers are listed, then I can click on the customer I want to look at and behind the customer's name will be the code to open the correct workbook and show me the info I need. I know that I need hyperlinks from the row of Alphabet on the top of the screen to it's portion of the lists - that I can do okay. What I don't actually know is how to create a form so I can design it the way that I want it, and then put a shortcut on the user's desks so that when they click it, my form comes up, they make their choices, the code runs behind the customer name they chose, and they get the info they need. Would this be considered a type of splash screen - maybe without the timer feature attached to it so that it will stay open until the 'close' button puts everything away and closes the little app? Your advice and help are as always very much appreciated. TIA Joanne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
User Form
Have a look at http://www.contextures.com/xlUserForm01.html and/or
http://www.contextures.com/xlUserForm02.html "Joanne" wrote in message ... I am using winxp pro and msoffice 2003 I have never done a user form in excel and am not sure how to proceed. This is what I want to do: Make a user form with the alphabet across the top of the form, each letter of the alphabet links to a listing on the form, such as: If I click on "C", I go to the portion of the form where my "C" customers are listed, then I can click on the customer I want to look at and behind the customer's name will be the code to open the correct workbook and show me the info I need. I know that I need hyperlinks from the row of Alphabet on the top of the screen to it's portion of the lists - that I can do okay. What I don't actually know is how to create a form so I can design it the way that I want it, and then put a shortcut on the user's desks so that when they click it, my form comes up, they make their choices, the code runs behind the customer name they chose, and they get the info they need. Would this be considered a type of splash screen - maybe without the timer feature attached to it so that it will stay open until the 'close' button puts everything away and closes the little app? Your advice and help are as always very much appreciated. TIA Joanne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
User Form | Excel Discussion (Misc queries) | |||
user form | New Users to Excel | |||
User Form Still Trying | New Users to Excel | |||
user form | Excel Discussion (Misc queries) |