Results 1 to 11 of 11

Input form with criterion-based selection list

Threaded View

TPFKAS Input form with... 12-24-2009, 11:51 AM
Palmetto Re: Input form with... 12-24-2009, 12:01 PM
TPFKAS Re: Input form with... 12-24-2009, 12:41 PM
Palmetto Re: Input form with... 12-24-2009, 12:52 PM
TPFKAS Re: Input form with... 12-24-2009, 01:04 PM
  1. #1
    Registered User
    Join Date
    12-22-2009
    Location
    Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    23

    Input form with criterion-based selection list

    Hi Guys,
    Thanks to the great help I was able to build the attached application. It's purpose is to keep track of take-offs and landings for our gliding club.
    I am happy with the way I can add flights (using the button "Add flight") in the list now and I am now turning to a nice way to register landings.
    I have implemented a macro that just puts a timestamp in the active cell and that works OK. I can use it to register the landing time.
    However, I'd like to make it more fancy. I would like to have a button called "Close flight". When pressed a form or a window should appear with all open flights (i.e. all rows in the spreadsheet that are not empty but have no landing time, that is cell in col. G is empty). The user should then be able to select one. Press on a button called "Now" or enter a time manually which then is put into the spreadsheet.

    Maybe a complicated story, but the attached example should make things clear.

    Anybody care to help how I should achieve this?

    TIA
    Attached Files Attached Files
    Last edited by TPFKAS; 12-27-2009 at 05:22 PM.

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