+ Reply to Thread
Results 1 to 4 of 4

VB coding for using userform to edit and overwrite an existing database/worksheet

  1. #1
    Registered User
    Join Date
    04-28-2015
    Location
    bangalore
    MS-Off Ver
    2013
    Posts
    56

    VB coding for using userform to edit and overwrite an existing database/worksheet

    Dear Experts,

    I've tried to make userforms for a succession plan office project.

    The information is shown in textboxes and I expect the changes made in those textboxes will overwrite the existing initially entered information in the "Sheet1"; but that's not happening.
    I also wanted to have a combobox with just the company name to filter/dropdown.
    The template is attached herewith.

    Please do the needful.

    Thanks
    KumarPK
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: VB coding for using userform to edit and overwrite an existing database/worksheet

    Hi KumarPK

    This Code is in the attached. Please note the Public Variables in Module 1
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    04-28-2015
    Location
    bangalore
    MS-Off Ver
    2013
    Posts
    56

    Re: VB coding for using userform to edit and overwrite an existing database/worksheet

    Wonderfull... Thank you so much, working perfect.!!!!!!!!!! You have save my day...

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: VB coding for using userform to edit and overwrite an existing database/worksheet

    Hi KumarPK

    You're welcome...glad I could help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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 Have Text Boxes Auto Populate Based on Combobox Selection & overwrite existing da
    By Rajesh shishodia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2015, 02:06 AM
  2. Help with coding an edit row button form a userform
    By Stephen_Malley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2014, 07:53 AM
  3. [SOLVED] Overwrite or Replace existing Worksheet with VBA
    By Davidp06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2014, 07:48 PM
  4. VB coding for using excel userform to edit and overwrite an existing database
    By raseen20 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2013, 10:35 AM
  5. Replies: 1
    Last Post: 03-26-2013, 10:09 AM
  6. [SOLVED] Copy worksheet from one WB to another, overwrite existing worksheet with same CodeName
    By Renns in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 08-31-2012, 10:30 AM
  7. edit the existing userform
    By barishta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2009, 01:36 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