Need help w/ Visual Basic and Macros for big wkbk

[Wynn]

I have a very big and formula-ridden workbook that I have
been using to track document review for a large lawfirm.
Neither the attorneys or paralegals are very good w/
technology and both groups are afraid of excel.

I would like to have an introductory page where I could
list thing like:

Would you like to see the repository index?
Would you like to print a list of the documents that have
arrived at the firm?
Would you like to see the key for abbreviations terms?
Would you like to add new boxes that have arrived?

For each of their selections, I would like to run a macro.
I have some experience writing Macros, but I think that I
need a good tutorial on how to set something like this up.

The most complicated thing I would like to do is to set-up
message boxes that would allow the user to enter the
number on the boxes that came in. This information I would
like to add to the index and then have a series of
functions follow. Can anyone direct me to some good sites
that might help me?

Thank you for reading all of this.

 

[JE McGimpsey]

I would suggest showing a userform with Option buttons and spinners.


Here's a message from the archives that has some good userform links:

http://google.com/groups?threadm=#Xje25x#[email protected].
gbl

 

[Wynn]

Thank you very much, this looks just like what I need! If
you or anyone else has any other suggestions I would be
very appreciative as well!