+ Reply to Thread
Results 1 to 7 of 7

Editing data by selecting it in one userform and editing in another userform.

  1. #1
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    82

    Editing data by selecting it in one userform and editing in another userform.

    Hi everyone

    I have question about this tutorial:

    https://www.onlinepclearning.com/edi...om-a-userform/

    Is it possible to select the row that I want to change and transfer it to another userform and edit there?

    By changing this code:

    Please Login or Register  to view this content.
    to this code:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    2,293

    Re: Editing data by selecting it in one userform and editing in another userform.

    What is the point? why not upload/download direct from the same sheet.

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    82

    Re: Editing data by selecting it in one userform and editing in another userform.

    Quote Originally Posted by torachan View Post
    What is the point? why not upload/download direct from the same sheet.

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    I don't have a workbook for it, I was wondering if it's possible to edit with the code I wrote.
    in this tutorial, he made a userform to enter employee's information in a worksheet and he's showing how to edit/delete them. However, if the userform has many text-, Combo-boxes, there won't be enough space to add a list-box for editing.
    so I though maybe it would be better to make another userform for searching and finding the employee-info that we want to edit then transfer the data to the first userform and edit there.

    (I hope I explained better this time )

  4. #4
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    2,293

    Re: Editing data by selecting it in one userform and editing in another userform.

    Use a single userform with a multipage on it.
    declare all your variables at the head of the userform module, that way they will be available to every sub.
    however a great amount can be put on one userform
    the attached example deals with this in a very compact form
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    82

    Re: Editing data by selecting it in one userform and editing in another userform.

    Quote Originally Posted by torachan View Post
    Use a single userform with a multipage on it.
    declare all your variables at the head of the userform module, that way they will be available to every sub.
    however a great amount can be put on one userform
    the attached example deals with this in a very compact form

    I see.
    Does it also work for combobox? to select an employee and change her/his position?

  6. #6
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    2,293

    Re: Editing data by selecting it in one userform and editing in another userform.

    Same form attached adapted with combobox replacing listbox.
    There is a textbox over the combobox for entering new data.
    Remember to clear form prior to making new entry.
    torachan.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    82

    Re: Editing data by selecting it in one userform and editing in another userform.

    Quote Originally Posted by torachan View Post
    Same form attached adapted with combobox replacing listbox.
    There is a textbox over the combobox for entering new data.
    Remember to clear form prior to making new entry.
    torachan.
    Thank you

+ 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] UserForm - Editing data via TextBoxes from ListBox
    By Manchester.Matt in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-25-2020, 03:57 AM
  2. Getting #Value afte editing Data on userform
    By farhadj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2017, 05:10 PM
  3. need help editing data with a userform.
    By Kvasir15 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2015, 02:12 PM
  4. Editing Userform Data
    By cmoore24 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-20-2015, 09:42 AM
  5. Editing data in userform and transferring back into row it came from
    By NellieNoggs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2014, 06:53 AM
  6. Loading and Editing Data from Userform
    By Gazmon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2013, 07:49 PM
  7. Editing Data Through A Userform
    By WoodsyMP5K in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2012, 02:30 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