open an input screen

please help

i have a list of names each with a button next to it and when pressed i
would like to open a form with their name in it. also in this form i would
like a drop down list with
FDA 1, OTDR 1, FDA 2, INTERIM, FDA 3, OTDR 2, FDA 4, SUMMARY.
next to this is it possible to have a date picker so to make it easier for
the inputter.
now when they press ok i want the date placing below the relevant item
for instance:

if they chose fda 3 and date 15-mar-06 and pressed ok.

cell g5 is the space for the date of fda 3
and this is where 15-mar-06 would appear

thanks in advance

For a calendar control:
http://www.rondebruin.nl/calendar.htm

for userforms and commandbuttons:

See this tutorial here
http://www.*****-blog.com/excel/2004...g_userfor.html


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

XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514


XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749


Here are some other sources of information:


http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel
http://support.microsoft.com/default...b;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.../Introductiont...
Part II
http://msdn.microsoft.com/library/en.../Introductiont...


--
Regards,
Tom Ogilvy



"cityfc" <[email protected]> wrote in message
news:[email protected]...
> please help
>
> i have a list of names each with a button next to it and when pressed i
> would like to open a form with their name in it. also in this form i would
> like a drop down list with
> FDA 1, OTDR 1, FDA 2, INTERIM, FDA 3, OTDR 2, FDA 4, SUMMARY.
> next to this is it possible to have a date picker so to make it easier for
> the inputter.
> now when they press ok i want the date placing below the relevant item
> for instance:
>
> if they chose fda 3 and date 15-mar-06 and pressed ok.
>
> cell g5 is the space for the date of fda 3
> and this is where 15-mar-06 would appear
>
> thanks in advance
>