+ Reply to Thread
Results 1 to 6 of 6

Userform for count between two dates according to specific name

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Userform for count between two dates according to specific name

    Hello everyone
    I have a userform that conatins some textboxes and some checkboxes
    I need to select some of these checkboxes and may be all would be selected according to the user
    Start date will be typed by the use and also the end date .. and a name selected from combobox ..
    Based on the data provided in start date and end date and the name selected from the combobox .. I need to count only textboxes below each checked checkboxes ..
    There is an example of the desired result in my attachment in remarks columns
    I appreciate any help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Userform for count between two dates according to specific name

    Is every thing is clear ?
    May anyone help me?

  3. #3
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: Userform for count between two dates according to specific name

    It looks like you haven't done much preliminary work here.
    You have no code to populate the combo box, you don't have a list of names anywhere to make it easier for someone else to populate the combo box. You don't have a list of types anywhere. This would all lower the workload of someone who would attempt to help you.

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Userform for count between two dates according to specific name

    Thanks Mr. Bruce for reply
    In fact there is already named range "hhh" for row source of the combobox ..and there is nothing to be done as for the combobox ..
    As for list of types ..what need for that list ..? the types are in column D
    And my need to count each type for specific name between two dates ..
    I appreciate your reply a lot

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Userform for count between two dates according to specific name

    Is this still considered workload ...?
    Need an example of how to use sumproduct that is used to count with conditions in VBA?

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Userform for count between two dates according to specific name

    Any help in this topic please ..
    It is kind of sumproduct but using vba ..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to substract two dates columns and count for specific days
    By Zuluwaco in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-26-2015, 10:53 AM
  2. [SOLVED] Count unique dates under a specific condition
    By jyothijayanna in forum Excel General
    Replies: 6
    Last Post: 12-28-2014, 11:21 AM
  3. Replies: 2
    Last Post: 12-17-2013, 06:30 AM
  4. [SOLVED] Count number of specific dates within several years
    By thed85 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2013, 12:55 PM
  5. Userform textbox specific character count
    By newty in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2013, 11:12 AM
  6. Having a formula count only specific dates.
    By szm187 in forum Excel General
    Replies: 3
    Last Post: 03-15-2012, 11:28 AM
  7. Count values in a range that appear for specific dates
    By galvinpaddy in forum Excel General
    Replies: 1
    Last Post: 11-02-2011, 03:45 PM

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