+ Reply to Thread
Results 1 to 6 of 6

update table based on the selection in userform

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-24-2013
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    199

    Re: update table based on the selection in userform

    that wasfast can you also help on reset and close button?

  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: update table based on the selection in userform

    Hi melody

    Close Button:
    Private Sub CommandButton3_Click()
       Unload Me
    End Sub
    Reset Button:
    Private Sub CommandButton2_Click()
       Me.ComboBox1.ListIndex = -1
       Me.TextBox1.Value = ""
       Me.TextBox2.Value = ""
       Me.TextBox3.Value = ""
    End Sub
    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.

+ 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. Trying to update an access table from Excel based on unique ID. rst.Update not working
    By Newbie0924 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2015, 04:15 PM
  2. [SOLVED] Select date userform based on Userform selection
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2014, 10:45 AM
  3. Update formula in cells based on list selection
    By XLNB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2014, 03:39 PM
  4. [SOLVED] How to update form label caption based off selection
    By cameron213 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2014, 03:22 PM
  5. Update excel based on userform text box update
    By sivakumar123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 01:01 AM
  6. Update List of Fixtures based on Selection
    By mccrimmon in forum Excel General
    Replies: 2
    Last Post: 06-10-2011, 10:53 AM
  7. Update formula based on cell selection
    By Maver1ck666 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-01-2010, 09:49 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