+ Reply to Thread
Results 1 to 6 of 6

how to code a userform to take average of row starting and ending at selcted dates

  1. #1
    Registered User
    Join Date
    11-08-2011
    Location
    bergen county, NJ
    MS-Off Ver
    Excel 2007
    Posts
    72

    how to code a userform to take average of row starting and ending at selcted dates

    hi,
    I am trying to create a userform that will allow a teacher to select two dates, from two different comboboxes, and then have the average of the row of data calculated from the starting and ending date.

    each column would be the date.

    any help would be much appreciated !

    thanks!
    teacher_rob
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: how to code a userform to take average of row starting and ending at selcted date

    Hi

    Which row of data are you actioning? Or is it all of them? And where does the result go?

    rylo

  3. #3
    Registered User
    Join Date
    11-08-2011
    Location
    bergen county, NJ
    MS-Off Ver
    Excel 2007
    Posts
    72

    Re: how to code a userform to take average of row starting and ending at selcted date

    in theory, i'd like the average for each class to be displayed from start to finish dates. i figure if someone can show me how to do anything at all, i'll be able to extrapolate.

    thanks !

    -rob

  4. #4
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: how to code a userform to take average of row starting and ending at selcted date

    Rob

    OK. Your attachment (I'm sure there was one at one stage) seems to have gone missing. Can you please resubmit.

    rylo

  5. #5
    Registered User
    Join Date
    11-08-2011
    Location
    bergen county, NJ
    MS-Off Ver
    Excel 2007
    Posts
    72

    Re: how to code a userform to take average of row starting and ending at selcted date

    yes, i'll get the attachment back later today. happy holidays everyone !

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: how to code a userform to take average of row starting and ending at selcted date

    Pl see the attached file.Any clarifications welcome.
    Attached Files Attached Files

+ 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