Data Form (ignore previous one)

[Darin Kramer]

Hi there,

Some questions relating to the use of a data form...

1) I would like to customize the standard excl form - ie currently in
the top right hand corner it says Field 1 of 2 (if there are two
fields), I want to replace the 1 with my own number and / or text

2) to launch the field - can it be automated depending on a result in
another cell? (Simple macro to launch it?

Thanks and regards

D

 

[Bob Phillips]

You will need to build a custom userform for that.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Darin Kramer]

How do you build a customer User form?

 

[Bob Phillips]

Here are some links to get you started, as listed by Tom Ogilvy

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

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97

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


--

HTH

RP
(remove nothere from the email address if mailing direct)