kevinc1973
New Member
- Joined
- Jun 20, 2019
- Messages
- 23
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
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