I have a userform checkbox that I need to have send a "Yes" or "No" to my worksheet. When "Save" is selected, it adds the info from the userform to the last row of the Excel table. I added the code below, and it returns True/False on the row with the data from the userform, and no data on the next row, only Yes/No. Basically, everything works, but the Yes/No needs to be 1 row higher in place of the True/False. I am new to VBA, and have searched for a solution, but can't seem to make anything work. Any ideas how to fix this?
vba4.JPG
Bookmarks