Creating a macro (or module) to modify a cell's value based on automated entries

Hello All,

I'm in need of your vast expertise to resolve a problem I have with a userform I created in Excel 2010. The form collects information from a label via scanning (two scans of the same label, the first one for the Item ID (restricted to seven characters in the text box) and the second one for the Item P.O. (all fourteen characters of the label)).
The first scan output is placed in cell B14, then is validated by a table and the Item ID info is displayed in cell C14, the output for the second scan is placed in cell D14, gets validated and the Item P.O. info is displayed in cell E14; the process goes on and covers a range of B14:E28. The problem I'm facing is that I need to make the process of displaying both the Item ID and Item P.O. work with only one scan instead of two, so that the single scan can validate two entries with different length requirements in different cell targets.
I'm looking for your help to come up with a macro or a module that either restricts the number of characters in the first cell (B14:B28) or modifies the data in the second cell (D14:D28) to seven characters and then places the modified data in the first cell, without changing the data in the second cell or putting a formula in the first cell.
Please let me know if you need more information on either the process or the aim of the macro/module and I'll post the required info. Thank you in advance for any help you can provide.

Hi, Julez80s,

have you tried assigning the contents of trhe scan to a variable and then using Left(yourVariable, 7) for filling the first box?

Sample for getting the idea:

Please Login or Register  to view this content.

Ciao,
Holger

Hi, Julez80s,

itīs easy for me to tell what to do if I donīt know how the data is comning into the form (and what data in which form).

The first one doesn't give me an output on the first cell

Letīs add a check for the length of the text in that textbox (you may change it to your needs, here is just for any information at all):

Please Login or Register  to view this content.

Ciao,
Holger