+ Reply to Thread
Results 1 to 3 of 3

Userform Issues

  1. #1
    Forum Contributor
    Join Date
    02-25-2010
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    138

    Userform Issues

    Afternoon All,

    I am in need of some assistance....

    I have bodged some code based on an example that I have found online and I have somehow broke it....

    It works about 95% of what I need, but the last 5% has completely baffled me....

    This is the example I found online (Originally from http://www.ozgrid.com/forum/showthread.php?t=182598 )
    DaveExcelFile.xls

    Now I have amended the amount of boxes on there and edited the coding to the correct sheet names, the 'New Entry' tab on the UserForm works fine, The 'Edit Entry' tab picks up the correct information from the drop down box, The 'Edit' button works correctly but the 'Delete' and 'Save' buttons do not become accessible as per the original file....

    Here is my botched test page for your perusal....

    TEST3.xlsm

    Any assistance would be greatly appreciated.

    EDIT:: The 'Delete' button can be removed.

    Many Thanks
    Ross
    Last edited by Rosco88; 01-08-2015 at 09:14 AM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Userform Issues

    You need to add in the lines that you've deleted here:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-25-2010
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    138

    Re: Userform Issues

    Cheers Kyle.

    Figured it out just as you replied....

    It's the cmdSave.Enabled = True

    That I was missing.

    Cheers
    Ross

+ 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. Userform issues
    By xia0jj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2014, 03:13 AM
  2. [SOLVED] VLookup in UserForm VBA issues
    By wanamaa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2013, 12:22 PM
  3. UserForm-Listbox-Issues, Data To & From Excel Cells Not Working; Null Values
    By Kalithro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2013, 12:43 AM
  4. userform.show issues
    By ag273n in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-30-2013, 11:47 PM
  5. USERFORM - Issues Log Template
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2013, 09:50 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