+ Reply to Thread
Results 1 to 2 of 2

open an input screen

  1. #1
    cityfc
    Guest

    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


  2. #2
    Tom Ogilvy
    Guest

    Re: open an input screen

    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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1