+ Reply to Thread
Results 1 to 10 of 10

Create new sheet based on date selected (userForm)

  1. 12-16-2011, 07:03 AM #1
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Question Create new sheet based on date selected (userForm)

    Hi Folks

    Please help me to create new sheet based on date selected in userform (Sheet Name = Date). I have attached a file of what I'm trying to accomplish. Thanks in advance for your expertise!


    Joshi
    Attached Files Attached Files
    Last edited by krjoshi; 12-17-2011 at 04:03 PM.
    Reply With QuoteRegister To Reply
  2. 12-16-2011, 07:18 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: VBA Help needed to create new sheet based on date selected (userForm)

    Understood your problem. So if the sheet already exists, the data should just be appended below right?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  3. 12-16-2011, 07:21 AM #3
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Help needed to create new sheet based on date selected (userForm)

    Hi arlu

    Yes, you are right. Can you please help me?

    Thanks

    Joshi
    Reply With QuoteRegister To Reply
  4. 12-16-2011, 07:24 AM #4
    Kyle123
    Kyle123 is offline
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: VBA Help needed to create new sheet based on date selected (userForm)

    maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 12-16-2011, 07:43 AM #5
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Help needed to create new sheet based on date selected (userForm)

    Hi Kyle,

    Your code is OK. Still having some errors. 1) Your code is pasting the data into Row1 "A1" but I want to paste into Row2 "A2". 2) If the sheet is already exists I want show a warning message like "The Sheet Already exist. The data you have selected copied" and the data should just be appended below into same selected sheet. 3) The "Data" sheet always stays first in the workbook. 4) Once the new sheet created activate the same sheet and always select 1st row "A1".

    Thanks

    Joshi
    Reply With QuoteRegister To Reply
  6. 12-16-2011, 09:15 AM #6
    Kyle123
    Kyle123 is offline
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: VBA Help needed to create new sheet based on date selected (userForm)

    in that case:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 12-16-2011, 03:37 PM #7
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Help needed to create new sheet based on date selected (userForm)

    Hi Kyle,

    It’s almost OK, still one small error. If i select date continuously its working well . If i select previous date getting this error
    Run-Time error ‘1004’:
    Select method of Range class failed.

    I hope this also you can resolve.

    Thanks
    Joshi
    Last edited by krjoshi; 12-17-2011 at 06:46 AM.
    Reply With QuoteRegister To Reply
  8. 12-17-2011, 12:10 PM #8
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Help needed to create new sheet based on date selected (userForm)

    Hi Kyle,
    Please help me..

    Thanks,

    Joshi
    Reply With QuoteRegister To Reply
  9. 12-17-2011, 03:05 PM #9
    Kyle123
    Kyle123 is offline
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: VBA Help needed to create new sheet based on date selected (userForm)

    Ok try this:
    Please Login or Register  to view this content.
    Last edited by Kyle123; 12-17-2011 at 04:09 PM.
    Reply With QuoteRegister To Reply
  10. 12-17-2011, 04:03 PM #10
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA Help needed to create new sheet based on date selected (userForm)

    Thanks,

    Its working great...Thanks a lot.

    Joshi
    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)

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