+ Reply to Thread
Results 1 to 4 of 4

add data from userform without opening the targetsheet

  1. #1
    Registered User
    Join Date
    07-02-2018
    Location
    australia
    MS-Off Ver
    2016
    Posts
    60

    add data from userform without opening the targetsheet

    Good afternoon all

    Hope all had or is having a happy new year

    I'm trying to add data from a user form to a specific sheet
    I can do this but i don't want to see the target sheet
    i want to remain on the current sheet

    Please Login or Register  to view this content.
    Last edited by danny25; 01-01-2022 at 03:49 AM. Reason: solved

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: add data from userform without opening the targetsheet

    Please Login or Register  to view this content.
    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 star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    07-02-2018
    Location
    australia
    MS-Off Ver
    2016
    Posts
    60

    Re: add data from userform without opening the targetsheet

    Quote Originally Posted by sintek View Post
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Thanks sintec
    you have to be the most knowledgeable help here
    hope you can help in future projects
    again thanks

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: add data from userform without opening the targetsheet

    you have to be the most knowledgeable help here
    Nope...Is just as my Signature says...

    Untitled.png

    Happy Coding...

+ 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] When opening more than one excel file, the userform does not read the data from the main
    By saftawy1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-31-2021, 01:10 PM
  2. Replies: 0
    Last Post: 03-03-2021, 06:02 PM
  3. Populate Listbox1 with data from a named range when opening userform
    By mhamm26 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-04-2017, 09:40 AM
  4. Place picture in a targetsheet in one row
    By WilVerstappen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2016, 03:55 PM
  5. Place picture on targetsheet
    By WilVerstappen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2016, 04:01 AM
  6. [SOLVED] Code error opening userform for data entry
    By dwheggen1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2015, 02:14 PM
  7. [SOLVED] userform opening on sheet2 but not showing combobox data values
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2014, 08:29 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