Results 1 to 4 of 4

Use a userform to pass values from combo box to autofilter with custom filter for dates

Threaded View

Megatronixs Use a userform to pass values... 10-28-2013, 10:12 AM
Megatronixs Re: Use a userform to pass... 10-29-2013, 01:37 AM
Megatronixs Re: Use a userform to pass... 10-29-2013, 08:06 AM
Megatronixs Re: Use a userform to pass... 10-29-2013, 10:30 AM
  1. #2
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: Use a userform to pass values from combo box to autofilter with custom filter for date

    Hi all,

    To make things easier I have added a workbook with a userform attached.
    When you press the edit data button, you get an userform. It has 4 comboboxes and a OK and exit button.
    The idea is that when you click on the edit data button you will be able to select a person, choose the date from, choose the date to and the reason. the only thing that will be filled in by the userform is the reason in column E. Maybe it is better to say that when you select the person and the dates, it will create a range for that person in the chosen dates and only fill column E with whatever the choice was.
    In the workbook I have added a sick leave period from the 12th 11 till the 19th 11 for Jesica Poter.

    Any ideas getting this going?

    Greetings.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Autofilter Custom Filter VBA
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-18-2013, 04:30 AM
  2. Pass Date value from custom calendar control to Userform Combo Box:
    By rvc81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2013, 12:59 AM
  3. Pass a simple value from custom UserForm to VBA module
    By MSieg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2012, 04:25 AM
  4. filter from combo box? (not autofilter)
    By Excel idiot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2007, 05:31 PM
  5. Pass Combo Values to an ODBC Parameter........
    By Jonathan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2005, 08:05 AM

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