• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

After I run my macro, one column shows #NA

rhibrown

New Member
I've created a macro to add and edit rows in my spreadsheet.

When I edit one, it will change column Q to #NA.

Any help would be greatly appreciated.
 

Attachments

  • File.xlsm
    142.5 KB · Views: 5
Which macro causes this? Are you getting an error message?

The Add/Edit button - in the userform, when you select an item from the list, and change one of the textboxes, and then press edit. If you go back to the spreadsheet, it was show #NA in column Q.

I hope that makes sense.
 
Unable to test. Get a message that certain items needed to run the codes are not present in this file and does not load the form.Capture.JPG

Turns out Microsoft Windows Common Controls is missing from my machine. When I try to locate to load, it is not available to me. I will pass on assisting at this point and let someone else jump in as I am stymied.
 
Last edited:
Back
Top