+ Reply to Thread
Results 1 to 10 of 10

Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

  1. #1
    Registered User
    Join Date
    05-18-2020
    Location
    -
    MS-Off Ver
    2019
    Posts
    21

    Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

    Hello Everyone!

    I'm working on a personal project but got a issisue. I made a Userform about Data Saving it works well. No Problem on it.
    I have 1 Combobox (named as X) and It has sub names. I wanna do that if while saving datas I chose a sub name in combobox then save datas main sheet ( name is Datasaving) also Copy it to the named Sheet which is selected in Combobox.

    I should say I've been learning VBA since for awhile.(Honestly not long).

    Thank you and sorry about my bad grammer from now.
    Attached Files Attached Files
    Last edited by SkyGod; 06-10-2020 at 06:21 PM.

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

    Hello SkyGod & welcome to the forum

    If my understanding of your request is correct, the below code should copy the entered data in sheet to the selected sheet as well. I have amended your code a little for unnecessary repeated lines of code … Let me know if this help

    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  3. #3
    Registered User
    Join Date
    05-18-2020
    Location
    -
    MS-Off Ver
    2019
    Posts
    21

    Re: Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

    Hello, nankw83
    You are Awesome! it works very well. That's what I wanted and was looking and with your codes the excel kind of working a bit more fast. I guess my codes were making slow the program.

    My appreciated!

  4. #4
    Registered User
    Join Date
    05-18-2020
    Location
    -
    MS-Off Ver
    2019
    Posts
    21

    Re: Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

    ''' why clear the data ? let the user edit it instead of retyping all data again
    ACtually it was clear the from after saved. Also if someone want removing the fields quickly to go new one. Like I said I'm new on VBA. i couldnt get most of the codes what they have meaning in VBA. Learning step by step by trying.

  5. #5
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

    Glad to help & thanks for the reps

    I used "Unload Me" if data is transferred to the sheet which presumably the user is done. You already have a "Clear Form" button in your UserForm. It is great fun & very useful, enjoy coding !

    If the provided solution takes care of your original question, please mark the thread as 'SOLVED' by clicking the Thread Tools from the menu at the top of your first post

  6. #6
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

    slightly faster and shorter

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    05-18-2020
    Location
    -
    MS-Off Ver
    2019
    Posts
    21

    Re: Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

    Thank you so much for helping Vraag en antwoord , also your code is working well!

  8. #8
    Registered User
    Join Date
    05-18-2020
    Location
    -
    MS-Off Ver
    2019
    Posts
    21

    Re: Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

    How Can I add data "Date And Time" by new Data saving into H Column for each new data. Tried merging with the codes but got fail.
    Thank you for helping!

  9. #9
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

    I have highlighted in blue the changes you need to do to apply record data/time

    Please Login or Register  to view this content.

  10. #10
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Data Saving With UserForm + Also Copying The Same Datas to The Their Named Pages

    Keep it simple and fast.
    Please Login or Register  to view this content.

+ 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. Need vba code to print specific pages or all pages in a multipage UserForm
    By Pimp_mentality in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-24-2020, 08:13 PM
  2. Replies: 3
    Last Post: 03-11-2014, 12:28 PM
  3. Copying the row datas to another sheet if a cell is negative
    By naga in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-24-2013, 09:07 AM
  4. [SOLVED] Need VBA code for copying datas from different sheets to one sheet
    By kesavanprabhu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2013, 05:42 PM
  5. [SOLVED] Copy Data loaded via Userform to a worksheet named in 1 field of the Userform
    By audax48 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2012, 01:44 PM
  6. copying the datas along with the activex controls and pasting in another worksheet
    By share knowledge in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-14-2011, 01:30 PM
  7. Saving copying text files named in a column to a different location
    By twills in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2010, 08:44 AM

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