+ Reply to Thread
Results 1 to 13 of 13

Edit values in textboxes userform

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

    Edit values in textboxes userform

    Hello everyone,

    I made the userform from this website: https://www.excel-easy.com/vba/examp...-userform.html

    It should show be possible to edit the values from the datasheet. However this values are not shown in the userform. I have uploaded the file..
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Edit values in textboxes userform

    There's no userform, or code in that file

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Edit values in textboxes userform

    @travelkid

    You have had a response in this thread and as mentioned in your now closed duplicate thread you should not raise duplicate posts. That is contrary to our rules.

    Neither should you use the PM facility asking moderators to do so.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

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

    Re: Edit values in textboxes userform

    I have edited the file, which was not working in the first post. Sorry for the invonvinience. I am working on this problem fro quiet a while, need to get forward.
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Edit values in textboxes userform

    You will need to explain clearly what you are after.
    The reason that the userform is not populated with any values, is that you have no code doing that.

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

    Re: Edit values in textboxes userform

    If you click on the link you can see an interactive userform (https://www.excel-easy.com/vba/examp...-userform.html). So my goal is that the values from the datasheet are editable via the userform. --> I have posted a thread with a more complex file, that describes my ultimate goal.. However nobody answered there... (https://www.excelforum.com/excel-pro...-database.html).
    So what I want is a program, that allows me to change data from a datasheet (this will be the first step).

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Edit values in textboxes userform

    You have been here long enough to know we don't permit duplicate threads, you seem to have raised three on the same subject.

    You've also now mentioned that you've asked the same question on another forum. That should have been stated in your very first post here since we don't permit cross posting without references.

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Edit values in textboxes userform

    Richard, The link is to another duplicate thread in this forum.

    travelkid
    Please describe clearly what you are trying to do (in words), otherwise I cannot help.

  9. #9
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Edit values in textboxes userform

    Quote Originally Posted by Fluff13 View Post
    Richard, The link is to another duplicate thread in this forum.

    travelkid
    Please describe clearly what you are trying to do (in words), otherwise I cannot help.
    Hi Fluff.

    There were two links in #6. One to this forum and one to a site called excel-easy.com, although I see it's actually a broken link.

  10. #10
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Edit values in textboxes userform

    Excel-easy is similar to sites such as Contextures Able-bits etc, rather than a forum.

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

    Re: Edit values in textboxes userform

    I have datas in an excel sheet, which is my database. On my first userform I would like to show all the values from this database (This one is solved). In a next step I would like to be able to either create a new entry into the database or edit the existing ones (for this I have one button new and one button edit). When one of this buttons are pressed the net userform pops up, where I can enter either new values or edit the existing ones, depending on which button I pressed in the beginning. That is the description of my problem. I already have uploaded a file, where this can be done, however only in one userform. Also this program is not from me and I cannot understand the code fully. So to say it short, Im looking for a code that can edit values from a database. I have uploaded the original file once again, which now works. Therefore the problem of this thread is solved. If one wants to help with the original problem (the link to the other thread) I am grateful
    Best, Matthias
    Attached Files Attached Files
    Last edited by travelkid; 01-11-2019 at 03:59 AM.

  12. #12
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Edit values in textboxes userform

    Please do not use the messaging system to ask for help.
    I have only just logged on today & saw you message before I'd even seen post#11

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

    Re: Edit values in textboxes userform

    okey, well the main problem is still not solved..

+ 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] Pass values of UserForm TextBoxes to 2D Array
    By esbencito in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-26-2018, 05:20 AM
  2. populate textboxes in userform based on cells values
    By Yokosuka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2016, 01:50 PM
  3. copying and moving values in textboxes in VBA userform
    By Ibby12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-29-2016, 06:41 PM
  4. Getting values from dynamic textboxes on userform in array
    By nasdrasil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2014, 03:53 PM
  5. Replies: 3
    Last Post: 11-05-2014, 01:11 PM
  6. Populate row value in userform textboxes, edit and save the changes back in sheet.
    By p_nayak268 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2013, 07:48 PM
  7. Userform Textboxes showing wrong values?
    By Panic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2008, 09:43 PM

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