Results 1 to 10 of 10

1 of 2 userforms not working due to change event

Threaded View

bitly 1 of 2 userforms not working... 02-09-2016, 05:00 AM
davesexcel Re: Only 1 Cell updating in... 02-09-2016, 05:50 AM
bitly Re: Only 1 Cell updating in... 02-09-2016, 06:14 AM
davesexcel Re: Only 1 Cell updating in... 02-09-2016, 06:58 AM
bitly Re: Only 1 Cell updating in... 02-09-2016, 12:15 PM
bitly Re: Only 1 Cell updating in... 02-09-2016, 06:02 PM
bitly Re: Only 1 Cell updating in... 02-10-2016, 02:15 AM
davesexcel Re: Only 1 Cell updating in... 02-10-2016, 08:55 AM
bitly Re: Only 1 Cell updating in... 02-10-2016, 10:57 PM
bitly Re: Only 1 Cell updating in... 02-17-2016, 04:12 AM
  1. #1
    Registered User
    Join Date
    02-09-2016
    Location
    FL
    MS-Off Ver
    2013
    Posts
    7

    1 of 2 userforms not working due to change event

    I have an incomplete project I have been working on and do not want to move on until I get this problem resolved (little things like this bug me). Perhaps I just need a second pair of eyes. However, the problem that I am having is that I am using a userform to update cells in a sheet. I have 2 userforms that are very similar and one works and the other does not. The suppliers editing part of the program is working just fine. It updates as expected. The customers userform will only update the first name in the sheet; the other fields remain unchanged and refresh as the same while no changes are made in the sheet. I pretty much copied and pasted the code from the suppliers over to the customers and made all of the appropriate changes that I found. I have looked over it for hours on end and just cannot figure out why all of the information in the customers cannot be updated.

    On a side note, while I was cleaning out most of the records from the sheet I got errors when I cleaned all of the records out, I have no clue how to handle these errors when there is no information in the sheets for the userforms to pull up. This error is not as pressing to me since the sheet will never be empty when in use, but it still bothers me knowing its there and not handled.

    Thank you ahead of time for any help and sorry for the long first post, its 4 am. so it is possible I have rambled

    Bitly
    Attached Files Attached Files
    Last edited by bitly; 02-17-2016 at 03:51 AM. Reason: title change for clarity

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. update cell/cells after updating a textbox on a userform
    By 40jmart1705 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2014, 03:07 PM
  2. [SOLVED] updating a parent workbook from a child workbook via Userform
    By smooth_beaker in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-01-2013, 08:39 AM
  3. Excel VBA - 1 Workbook, updating a specified cell in another workbook
    By Jiggles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2010, 02:23 AM
  4. Dynamically updating userform that lists worksheets and allows to edit one cell
    By bujaman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2010, 02:16 PM
  5. Multiple cell updating using userform
    By AGrace in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2010, 06:22 AM
  6. Updating Data in Workbook using UserForm
    By DRkidd22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2009, 10:24 AM
  7. Using a userform for updating from closed workbook
    By ge0rge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2009, 07:20 AM

Tags for this Thread

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