I have a statement I am working on for the company I work for, & I am quite new to VBA formatting.
I have a userform that opens when the file is opened, and it has text boxes where you input job code information (date code, year code, job code, and letter code). That information is then pulled from another spreadsheet and inputted into the Invoice/Statement sheet into one cell. The issues I am running into is when the data is put in it is too large to show up in the cell. I need to figure out a VBA code to automatically format it by length of the data in that cell.
I would like for the code to merge down into however many columns it needs!
I attached some screenshots of the file to show the cell, and how I would like it to look afterward.
Again, I am a super newbie to VBA so if you have any pointers; that would be awesome!
Thank you so much!!