Userform textbox value to cell only if textbox not empty

[Catsonheat]

Hi all,

i have the below code:

Please Login or Register  to view this content.

When the submit btn is clicked it will past the value of the combobox followed by " - " to separate when it also pastes in the value from a textbox. The problem I am having is that this will populate each cell with " - " even if the combobox and textbox is empty which causes a few problems with reporting. I need this code to ONLY post to the cell if the combobox and textbox both contain text, if either of them are empty it will not post anything at all. I have tried a few solutions such as writing the code to clear cells if they equal " - " but it isnt very efficient. Can anyone advise of a quick efficient way to get this to work?

[Arkadi]

One idea, longer to type but more efficient that going back to clear them, also avoids the dash if only one of the two is blank and the other has something:

Please Login or Register  to view this content.

[Catsonheat]

Hi Arkadi, sorry for late reply but the above worked a treat, thanks for the help! Marked as solved and rep added.

[Arkadi]

Glad I could help
Thanks for the rep and marking the thread as solved!