Cells to Textbox, leave out blanks

[sunswan]

Its back to basics for me. I am transferring data by row from a sheet to textboxes. I wish not to have any blanks in my textboxes. I am at a loss as how this works. I have enclosed a simple sample of what I am doing. I wish to have the 5 show in textbox4, 6 in textbox5,etc. Thanks in Advance.