VBA to Automate the Delimiter

I'm attempting to find a solution using VBA to automate the delimiter and I've scoured the forums and internet to no resolve and was hoping I may be able to find an answer here. Right now I am having excel generate a barcode in the example format of "11D*122*1", each identifying number is split by the asterisk(11D 122 1). Then in the next process an end user will scan that barcode into the B4 field. Each number will change when a scan is entered into cell B4. Right now I am doing text to cell function so that it breaks it down and separates them in cells Z4:AB4 but I am looking for a way to automatically do this as this process will be for end users. Trying to find a way to do this that as soon as the data is entered it separates it without having to use a macro button or a formula as formulas within the cells are not carrying over any conditional formatting. Any help is appreciated and again thank you.

You my friend are amazing! I've been banging my head on this one for a couple days now trying to automate this as smoothly as possible without the use of a button. Thank you so much!

yes, sorry the link to the cross post was posted in the Mr.Excel forum board, I used a collaboration of both VBAs to get the desired effect thank you for time and help.
However your rules contradict themselves, it does not allow me to post a link as I have not posted enough, and I get an error when trying to post any link. I would have posted the link but it will not let me.