+ Reply to Thread
Results 1 to 2 of 2

edit values over two userfroms

  1. #1
    Forum Contributor
    Join Date
    12-11-2018
    Location
    Zurich
    MS-Off Ver
    2016
    Posts
    130

    edit values over two userfroms

    As one can see you can pick a entry from a database in the listbox from userform 1. If you press "bearbeiten" the values from that line appear in the next userforms textboxes. Now I would like to be able to change those values --> change the number and press again "bearbeiten" on userform 2, and afterwards they are written into Tabelle1. What I fail to do is to reference the database entry (f.e. the number) with the edit program in userform 2, that I have from another project. If one could help me with that, I would be grateful.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-11-2018
    Location
    Zurich
    MS-Off Ver
    2016
    Posts
    130

    Re: edit values over two userfroms

    --> Okey Ill try to get this goiing again.. So the following code allows to show and edit text box values in the same userform :

    Please Login or Register  to view this content.


    Here is what Im looking for:
    In the userform before I should find out how I can set a variable (the row number of the row I want to edit) and use this variable then in the second userform as default. To refer to the code --> I should fix the "fnd" variable in the first userform then save it and then plug in for the second userforms edit program. So how can I extract that variable from my data?

    Best. You could alos PM me if you have further quesitons.. Completly stuck with this problem...

+ 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. Edit values on Listbox
    By Rodas in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-30-2013, 10:46 PM
  2. [SOLVED] excel vba filter values to listbox from combobox and save edit values in textbox
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2013, 08:42 AM
  3. show multiple userfroms without passing control to any of them
    By TheNewGuy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2009, 10:17 AM
  4. Showing 2 Userfroms at same time
    By GuitarMyke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2007, 03:52 PM
  5. [SOLVED] Getting pre edit values
    By aps in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2005, 11:05 AM
  6. edit x-values in XY Scatter?
    By JethroUK© in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-28-2005, 08:06 PM
  7. [SOLVED] Edit/Find/Options/Look In/Values
    By Hi Ho Silver in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2005, 12:06 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