+ Reply to Thread
Results 1 to 8 of 8

Userform is not working.

  1. 05-24-2019, 03:03 AM #1
    jhakans
    jhakans is offline
    Registered User
    Join Date
    05-24-2019
    Location
    Sweden
    MS-Off Ver
    2013
    Posts
    13

    Angry Userform is not working.

    Hi!
    Im trying to extract specific data between two dates into another sheet with userform. But I dont know what im doing wrong..
    all help is welcome.


    error.JPG



    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by jhakans; 05-27-2019 at 11:30 AM.
    Reply With QuoteRegister To Reply
  2. 05-24-2019, 03:11 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,610

    Re: Userform is not working.

    Code tags added by OP
    Last edited by Pepe Le Mokko; 05-24-2019 at 07:07 AM.
    Reply With QuoteRegister To Reply
  3. 05-24-2019, 03:12 AM #3
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,610

    Re: Userform is not working.

    And while you are at it, please post a sample sheet ( pictures are useless). Click Go advanced - Manage attachments
    Reply With QuoteRegister To Reply
  4. 05-24-2019, 04:40 AM #4
    jhakans
    jhakans is offline
    Registered User
    Join Date
    05-24-2019
    Location
    Sweden
    MS-Off Ver
    2013
    Posts
    13

    Re: Userform is not working.

    Done! Thanks
    Reply With QuoteRegister To Reply
  5. 05-24-2019, 06:31 AM #5
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Userform is not working.

    Try this...
    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  6. 05-24-2019, 06:34 AM #6
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,410

    Re: Userform is not working.

    Is this the result you are looking for.
    I have just removed the two 'Trim' conditions.
    Also with your date logic you have to set the dates one day prior and one day after.
    To stop the screen jumping about include Screen Updating False/True at start & end of code.
    torachan.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 05-24-2019, 07:19 AM #7
    jhakans
    jhakans is offline
    Registered User
    Join Date
    05-24-2019
    Location
    Sweden
    MS-Off Ver
    2013
    Posts
    13

    Re: Userform is not working.

    Thank you so much! this was exactly what I was looking for
    Reply With QuoteRegister To Reply
  8. 05-24-2019, 08:00 AM #8
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: Userform is not working.

    ...................................................
    Thanks.gif
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] progress bar userform inside userform not working
    By kevinu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2018, 05:41 PM
  2. userform not working properly
    By shiva_raj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2017, 04:53 PM
  3. Why Isn't My Userform Working?
    By drsadistic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2014, 11:18 PM
  4. Printing a userform - Not working
    By excelenergy in forum Excel General
    Replies: 3
    Last Post: 03-13-2014, 03:09 PM
  5. [SOLVED] Gradually Fade Userform Into View [Userform Fade Out Working Already]
    By nadstradamus in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-05-2013, 04:12 AM
  6. Alt+Tab not working when an userform is opened
    By sivdin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2009, 06:34 AM
  7. Working with Cells on Userform
    By Jeff Ingraham in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2006, 01:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1