Update WS from user form

[KevBotes]

Hi all, i have the below code that i am using to update a spreadsheet based on the entries in both check-boxes and text-boxes on a form.

the check-boxes update just fine, but the text-boxes don't. not sure what i am doing wrong:

Please Login or Register  to view this content.

[davesexcel]

You may have to supply a sample, for somebody to look at, right now, like you said..it should work

[bakerman2]

If you use Application.Match you never Dim as Long, but as variant because Match can also return an error.

Please Login or Register  to view this content.

If you put a Stop point (F9) at the Not Iserror line you can see which value C holds. (maybe control names and headers don't match.)
Try to avoid the use of On Error Resume Next. The code doesn't stop but you can't also see where the error comes from.

[KevBotes]

i put a messgae box to test for row and column and content, all seem right.

I used:

Please Login or Register  to view this content.

.

if i comment out the line

Please Login or Register  to view this content.

, then nothing happens to the excel sheet for sure, but then the form retains all teh values. the minute i re-enable the line, then the forms text boxes loose their value.

Check boxes are not affected at all.

this is so weird. i just cannot figure it out.

[bakerman2]

Can u post an example file with your userform and some data to work with ?