Help with userforms in Excel 2000 (vba)

[Rachel Curran]

Hi,

I need help with the following - I need to create EASY userforms for a
data input team.

They will need to add:

*Their name (free text/string)
*Supervisor name(free text/string)
*Business (drop down list)
*Business Area ((drop down list)
*Business Sub Area ((drop down list
*Site (string)
*Reason for entry (drop down list)
*What the entry is (string)
*Employee number (9 digits max)
*Date of birth (dd/mm/yy)

I would like all this then to be written to a spreadsheet that only
authorised people can see. The userforms need to be shared aswell, as
more than one person at a time may be in the userform. Only want the
data input team to see the form NOT the spreadsheet.

Is this possible?

Would also like to add a background company picture to the and make it
user friendly as the data input team have limited IT skills.

Kind Regards

 

[Tom Ogilvy]

This should get you started.

After you get most of it working, post back with specific questions that you
haven't been able to solve:

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

How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;829070



http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: 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

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

 

[Harald Staff]

Adding to Tom's great list of clues: The only non-trivial thing in your list
is "that only authorised people can see". Spreadsheet files are not safe for
storing/hiding confidential data. Use another storage medium if this is
important.

HTH. Best wishes Harald