I need to create an invoice number based on the name of the product I am inputting. The name of the
invoice must be in the following format:
[1st four letters of the product name] + EXE + Date (format mddyy)
To get the name of the product, the end user is asked via InputBox. This result is defined as Entry1. So, if a
product is called BANANAS, the invoice needs to be called:
My dilemma is, I can't get
Excel to display the first four letters of Entry1. I already have it figured how to display as EXE53105. THAT particular
line of code being used is:
[B17] = "EXE" & Format(d, "mmddyyyy")
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
d was previously defined as the date.
If anyone could offer any suggestion, it would be most appreciated.
Thank you, as always!