J
Joanne
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
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