Hi All,
I have a VBA form which is complete, except for 1 code that I cannot get to work, basically when a user completes the form it enters the information in to the data sheet, but if the user leaves a cell on the form blank (may come back to update the cell at a leter date) i need a code that would insert "MISSING" into the cell, I used the following code which works but it overwrites the users input if they do add text to the cell when completing the form, CODE as follows;
Worksheets("TRAINING DATABASE").Cells(lastrow + 1, 2).Value = "MISSING"
The next following code puts the users input into the cell;
Worksheets("TRAINING DATABASE").Cells(lastrow + 1, 2).Value = TextBox2.Text
I have tried using various ways of doing this, one way was using 'Then' and/or 'IF' statement but i keep getting an error using 'Then' and/or 'IF'! any body have any ideas on how to use this code so that if the user inputs text it doesnt overwrite the users input and if the user does not enter code then it will enter "MISSING"
I appreciate all help on this matter
(please note i have tried to upload a small spreadsheet for viewing etc but I keep getting a error code on the upload page, maybe due to the ongoing site update.
Bookmarks