+ Reply to Thread
Results 1 to 16 of 16

DatePicker does not allow to use table filters

  1. #1
    Registered User
    Join Date
    04-30-2021
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    13

    DatePicker does not allow to use table filters

    Hello, everyone!

    I have been having problems with my DatePicker when I use filtres on my table. The DatePicker works just fine, but when I try to filter an error occurs. Does anybody know how to fix the problem? The problem is on .LinkedCell = Target.Address. I created the DatePicker using the Desing Mode.

    (I tried to attach the excel to clarify, but I can't be able to do it, do know why maybe 'cause I am new here I have no permission yet to do it )


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Please Login or Register  to view this content.
    Last edited by BiaMidori; 05-03-2021 at 09:37 AM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: DatePicker does not allow to use table filters

    Attachments can be always attached. read this and see if you can find out what you might be missing

    I hate date pickers, but ... it should work, we'll see once you attach your file, make sure it does not contain sensitive data
    Attached Files Attached Files
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    04-30-2021
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    13

    Re: DatePicker does not allow to use table filters

    Thanks, Keebellah! Here is the Excel
    Attached Files Attached Files

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: DatePicker does not allow to use table filters

    Thanks, but it doesn't work here because I do not the the ocx control file (mscomct2.ocx) on my system.
    That is what I meant with date pickers, they are not advisable if you do intend to share the file with other users.
    I cannot reproduce the error because nothing happens when I filter or whatever.
    Sorry but cannot help
    And why is that button in the table? what does it do there, I understand you use it to open the datepicker but why in that position? Cell B6?

  5. #5
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: DatePicker does not allow to use table filters

    Get rid of your DatePicker on the sheet and use it placed on a UserForm as per the attached file.
    Using it with a table - the table must have an active first data row - place data before double clicking in column 'B'
    The DatePicker is restricted to column 'B' of the table only, this will expand if you place data in column 'A' in the cell immediately below the table.
    Also attached my DatePicker (works without need for ActiveX - construct are low-level VBA controls).
    Like @Keebellah, I hate DatePickers AND Merged Cells.
    torachan.
    Attached Files Attached Files

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: DatePicker does not allow to use table filters

    And one more thing, because the button is inside the table it will become invisible when filtering so NEVER place floating shapes inside the area

  7. #7
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: DatePicker does not allow to use table filters

    @torachan: your datepicker file does not work on my laptop, missing object

  8. #8
    Registered User
    Join Date
    04-30-2021
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    13

    Re: DatePicker does not allow to use table filters

    Hi, Keebellah. I guess that the button that you referred it is the DatePicker, it's supposed to appear at the right of the cells in column A. But, I didn't know about all these problems using DatePicker... I understand now that it wouldn't be a nice idea to use it without as a UserForm, the file will be shared with other people. Thanks for advised me that.

    torachan your files work here! Ty so much, I will use it!

    Many thanks for your time, guys!

  9. #9
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: DatePicker does not allow to use table filters

    @Keebellah. Is it the DatePicker that does not work - ref your post #4 possiblly the reason ?
    but it doesn't work here because I do not the the ocx control file (mscomct2.ocx) on my system.
    but I would be concerned if my Calender did not work.
    torachan.

  10. #10
    Registered User
    Join Date
    04-30-2021
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    13

    Re: DatePicker does not allow to use table filters

    torachan I realize now that when I select a date using your DatePicker, the current excel file minimalize and change to the last file it was open. Any idea why?

  11. #11
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: DatePicker does not allow to use table filters

    Are you talking about 'DatePicker' or 'Calender' - both work OK at my end.

  12. #12
    Registered User
    Join Date
    04-30-2021
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    13

    Re: DatePicker does not allow to use table filters

    The DatePicker. I've tried to export the UserForm1, copy the code and create a new Useform, change .hide to "Unload UserForm1" but any of those things worked. Every time I select the date the excel change to the last window open. But when I deleted the "UserForm1.Hide" on "Private Sub DTPicker1_Change()", the excel didn't minimalize, but the UserForm didn't close too.

  13. #13
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: DatePicker does not allow to use table filters

    The DTPicker responds to two events - the 'Change' and the 'Click' events - both have to be present - the 'Change' works from the 'textbox' - the 'Click' works from the Calendar.
    Post the entire code - the userform code and the code in the worksheet module so that I can see what you have done wrong.
    Remember to place the code between code tags as required by Forum Rule #2.
    torachan.

  14. #14
    Registered User
    Join Date
    04-30-2021
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    13

    Re: DatePicker does not allow to use table filters

    torachan, the problem occurs even on the file you have sent. I've tried open in another computer but the situation persists. I realized that if I have a window open and then click directly in the excel file (without clicking to minimize the window), the problem occurs. But, if I first minimize the window and only then click on the excel, the datepicker works fine.

  15. #15
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: DatePicker does not allow to use table filters

    what other window have you got open when problem occurs.
    i have tried all combinations imagimable and cannot replicate what you describe.
    i am baffled without further details i find it difficult to offer an answer.
    torachan.

  16. #16
    Registered User
    Join Date
    04-30-2021
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    13

    Re: DatePicker does not allow to use table filters

    torachan, it is ok! I will use the calendar, it will be very useful! Thanks again for all your attention!

+ 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] Macro to select multiple pivot table filters, based on values in a table
    By Portuga in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2018, 06:42 PM
  2. Table Automatically Filters Entries to New Table Based on Criteria
    By Keats713 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-04-2017, 04:59 PM
  3. Pivot Table Filters - 1st filter also filters 2nd filter
    By Steveapa in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-19-2016, 03:32 AM
  4. Replies: 1
    Last Post: 07-16-2015, 05:46 AM
  5. [SOLVED] Link/Bookmark Datepicker to table heading
    By vamosj in forum Word Formatting & General
    Replies: 4
    Last Post: 11-25-2013, 02:33 PM
  6. [SOLVED] Create Filters for a Table based on what is visible in another table
    By GeneralDisarray in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2013, 03:48 PM
  7. Replies: 1
    Last Post: 09-11-2013, 02:27 PM

Tags for this Thread

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