Userform Entries not writing To Sheet

[liquidmettle]

Hello All,

So I find myself in a quandary, for I have userform code that *should* work but does not seem to want to (perhaps it's started Christmas Vacation early?)

Below is the code for my userform (including the relevant parts of the code for writing to the sheet). The thing is, I've used more or less identical code in another workbook and it worked just fine and dandy.

The userform is called via a beforedoubleclick event in column b. It pulls existing data from the sheet perfectly, just can't seem to nail the re-write.

Also, for the 6 checkboxes I have, I declared them as boolean. Will this result in a true/false in the cell on the sheet? (That's the result I'm hoping for). Also, when calling the information back up, will the chekcboxes stay checked if their reference cell has true or false? Is there something else I should keep in mind here? Note: If you need the code for pulling up the userform, let me know and I can provide it, just didn't want to muddle this post with too much.


Any assistance is greatly appreciated!

Please Login or Register  to view this content.

[Arkadi]

Any chance you can provide the workbook?

[Arkadi]

Oh! you are missing an else... right before "Defining Ranges" you need to add an "Elese". Right now the code is just skipping right over the whole defining ranges and updating sheet step.

Also, you have some boolean variables (Success1, etc) and then you are assigning them "ab" & .... which won't work.

[liquidmettle]

Arkadi!!!

You're awesome!

The dang little "else" was eluding me. I kept thinking the problem lie with with the actual worksheet ranges. Also I changed my booleans to variants which also did the trick.

Thank you so much!

If you would still like me to share the workbook let me know, I don't have any problem with doing so!

[Arkadi]

Nope, if your problem is solved I won't need your original... I wanted it to test your issue, then realized the lack of an "Else" meant your code was never being triggered.