Results 1 to 24 of 24

Vba code for userform to search by range of date

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2003
    Posts
    119

    Vba code for userform to search by range of date

    Hi guys

    Before my question i just want to say that this forum and the people here are amazing ;-)

    Ok, now to the point...Can anyone give me a hand with a code to this sample file?
    I have one file of this every month. In this sample i just have 2 materials, and this controls the stocks. I have design a userform with what i want (if its possible), and it consists in a combobox where i can select the material (in this sample there are LA-48, and Sact, but there are plenty more...maybe 20 but i hope that with your help with a code i can just add the others). Then i have two calendars where i introduce the start date and in the other the end date to use as a range to give me the sum of the inīs or the outīs, if i press one or another of this buttons (In / Out).
    The result should appear in the textbox below and in the last textbox should appear the actual stock at the end date selected on the calendar (End). If its blank, or 0,or negative it should appear that way in the textbox.
    Thanks in advance

    Sample file.xls
    Last edited by bazofio; 05-14-2013 at 03:25 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