Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
MSOffice 2003, winxp pro
I want to create a user form in my workbook to negotiate a long alphabetical list. I've seen this type of form on many web sites and think it could be well adapted to my perceived use. It typically has a control for each letter of the alphabet and when you click a letter, you go to that portion of the list. My use: Use it as a front page form for my master price workbook. User will click on an alpha, be taken by hyperlink to that part of the customer list, and when they click on the customer name, the code behind the name will open a 'copy of the master price workbook' adapted to show only the columns relevant to that particular customer. The only purpose of this little app is to allow the user to printout the pricing for their customer - so rocket science it is not. Still, I need help to get it going ;- ( A few years ago I remember doing a form with lots of controls like this alpha form would have, and it seems to me that there was a way to create the controls in a grouping type setting that would cause them to be uniform in size etc. I was learning visual basic programming at the time, but like they say, use it or lose it, and lose it I did. Been checking around googling on the net but cannot locate the info I need. Does someone know where I can get the info, maybe an example of this type of form and hopefully with some instructions on constructing it? Thanks for your help Joanne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Userform List box to Text Box | Excel Discussion (Misc queries) | |||
one userform to another | Excel Discussion (Misc queries) | |||
Userform | Excel Discussion (Misc queries) | |||
UserForm | Excel Discussion (Misc queries) | |||
Userform | Excel Worksheet Functions |