Text box and formulas

[kevinc1973]

Hello all,
I have a question that I hope I can explain it clearly but will give it my best shot. I am making a spreadsheet for chemical inventory and I created user forms to enter the data to the correct cells on the spreadsheets but just having trouble trying to figure out how to have a certain text box (text box 7) not write anything to the cell (I) if left blank. I want to put a formula in the cell of the spreadsheet (column I), if the text box is empty the formula would stay and if I put a number in the text box it would write over the formula. Is there a formula to not have the text box write to cell if left blank and where would I put the formula? Not sure if it would go under the command button to enter data or somewheres else? Thanks in advance

 

[6StringJazzer]

Yes, very simple. It's not a formula, but in the code logic. For a better answer, please show the code you currently have. It's going to be something like:

If TextBox7 <> "" Then
   Cells.(SomeRow, "I") = TextBox7.Value
End If
' if text box is blank, do nothing

but you didn't tell us how it's determining what cell to write to.

 

[kevinc1973]

Thanks that did work, I appreciate it, sorry about not showing code it was on my work computer. Thanks for your help