if textbox.value is not empty then

Hi im trying to add a form where by users can update certain cells in a spreadsheet based on the input in the userform

Please Login or Register  to view this content.

Text box 17 = Name or blank
TextBox38 = row reference (i.e 5)
Combobox6 is users choice (i.e red,blue,green)

What I want is if the texbox 17 is blank it does nothing, otherwise it adds it to the sheet using this code for column 108

Any idea how to do this as everything I have tried keeps telling me I have a mismatch, I have tried if greater than 0 on the cell reference boxes in this example that is tetxbox38, but still cant get it to work

Any help would be great thanks, Dan

Thanks il give that a go in the morning
😊

that doesn't show me the error anymore, but it doesn't paste the values from the combo box's into the sheet anywhere, it should be pasting into column DD (108) and then the row reference which is in textbox38 (5) so cell DD5

Whoops, sorry I had the row and column reference around the wrong way, have corrected this now and it works perfectly thanks