vba for isblank to enter values into form

Happy Monday, i am new to scripting vba from scratch. i have been using formulas to complete the task, but it is requested that i use a vba to eliminate the excess spacing needed for my formulas to work properly. i have multiple worksheets that i want to the data from to populate my form(s). if column A represents the selection of the item by entering the qty or no charge(NC). example of my worksheet is: sample sheet

i have the selected data in if isblank=false formulas that combines the selected line into one string for the order form. then i use the left, right, and mid formulas to separate the string into the columns needed for my check list form. what i want to do is eliminate using the one text string, and use the if isblank=false to populate my check list form.