Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 121
Default list userform

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform List box to Text Box hazel Excel Discussion (Misc queries) 1 September 16th 06 07:05 PM
one userform to another damorrison Excel Discussion (Misc queries) 2 August 26th 06 01:10 PM
Userform Jeff Excel Discussion (Misc queries) 0 February 6th 06 09:30 PM
UserForm CR Excel Discussion (Misc queries) 1 August 10th 05 10:26 PM
Userform Phil Excel Worksheet Functions 1 January 13th 05 06:36 PM


All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"