Books are useful, but with the development of the Internet, you can
find the answers to most questions online. You could also avail
yourself the resources of the local library. Anyway, ....
Everything that you are requesting sounds doable.
Here are some resources provided by Tom Ogilvy in a response to a
prior posting :
http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"
Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97
This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic
for
Applications macros that show you how to take advantage of the
capabilities
of UserForms and use each of the ActiveX controls that are available
for
UserForms
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data
http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data
John Walkenbach's site:
http://j-walk.com/ss/excel/tips/userformtips.htm
Userform Tips
Peter Aiken Articles:
watch word wrap. the URL should all be one line.
Part I
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartI.asp
Part II
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartII.asp
HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
Hi, i'm a new user of Macros/VBA and altho i'm slowly improving (mainly
thanks to theadvice on this forum!) i find myself stuck once again!
Snipped
Is this, or something like this, possible? Can anyone explain how i
should do it or point me in the right direction? Your help is much
appreciated.