+ Reply to Thread
Results 1 to 3 of 3

Making a macro interactive

  1. #1
    mmcfadd1
    Guest

    Making a macro interactive

    Hi, I'm trying to create a macro that looks up specific rows in excel for a
    given MM/YY. I would like to create a message box in which the user could
    scroll through a list and select the appropriate MM/YY and then the macro
    would target only those rows that are relevant to the given date.

    Any ideas? Thanks in advance.

  2. #2
    Tom Ogilvy
    Guest

    RE: Making a macro interactive

    This would need to be done with a userform


    http://j-walk.com/ss/excel/tips/tip84.htm

    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.


    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...FormsPartI.asp
    Part II
    http://msdn.microsoft.com/library/en...ormsPartII.asp


    --
    Regards,
    Tom Ogilvy

    "mmcfadd1" wrote:

    > Hi, I'm trying to create a macro that looks up specific rows in excel for a
    > given MM/YY. I would like to create a message box in which the user could
    > scroll through a list and select the appropriate MM/YY and then the macro
    > would target only those rows that are relevant to the given date.
    >
    > Any ideas? Thanks in advance.


  3. #3
    mmcfadd1
    Guest

    RE: Making a macro interactive

    Thanks! I appreciate it.

    "Tom Ogilvy" wrote:

    > This would need to be done with a userform
    >
    >
    > http://j-walk.com/ss/excel/tips/tip84.htm
    >
    > 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.
    >
    >
    > 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...FormsPartI.asp
    > Part II
    > http://msdn.microsoft.com/library/en...ormsPartII.asp
    >
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    > "mmcfadd1" wrote:
    >
    > > Hi, I'm trying to create a macro that looks up specific rows in excel for a
    > > given MM/YY. I would like to create a message box in which the user could
    > > scroll through a list and select the appropriate MM/YY and then the macro
    > > would target only those rows that are relevant to the given date.
    > >
    > > Any ideas? 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