leopardhawk
Well-known Member
- Joined
- May 31, 2007
- Messages
- 611
- Office Version
- 2016
- Platform
- Windows
Hello forum friends,
Need some help... I have a userform with eight textboxes that are set to transfer any data in them to specific cells on specific worksheets. I'm trying to figure out how to prevent the userform from transferring data from any fields that are left blank or empty by the user. They may simply want to update one field and I don't want them to have to re-enter all the other fields if that is the case. If there IS any data in a field, then it should be transferred but not if the field is blank. The way it is now, if I open the userform and then simply hit the OK button, it sends ALL the blank fields to my worksheet, something which will cause a lot of consternation with my users. I need it to only transfer data if the field contains something. I hope I am explaining this okay and that it makes sense.
Please let me know if you can help and whether or not you need more information (code etc.)
Thanks!
Need some help... I have a userform with eight textboxes that are set to transfer any data in them to specific cells on specific worksheets. I'm trying to figure out how to prevent the userform from transferring data from any fields that are left blank or empty by the user. They may simply want to update one field and I don't want them to have to re-enter all the other fields if that is the case. If there IS any data in a field, then it should be transferred but not if the field is blank. The way it is now, if I open the userform and then simply hit the OK button, it sends ALL the blank fields to my worksheet, something which will cause a lot of consternation with my users. I need it to only transfer data if the field contains something. I hope I am explaining this okay and that it makes sense.
Please let me know if you can help and whether or not you need more information (code etc.)
Thanks!