Leading Zeros being Deleted from Input Box Results

[jonathanramey]

I have a system that will ask the user to change the information used to make a sku if that sku is longer than 14 characters long, but if the input box has a result with leading zeros, they get deleted. Could I get some help as to how to keep those from disappearing?

[Artik]

Get the value of the cell containing the SKU as Text, not Value.

Artik

[jonathanramey]

Could you give me an example? I am not quite sure I understand. I am wanting to maintain the leading zeros from input box responses.

[Artik]

For example, instead of Range("A1").Value, use Range("A1").Text.
Artik

[mjr veverka]

1. Try not to use words in variable names that are the same as the names of methods, properties, functions, commands from vba
2. You can try with an apostrophe at the beginning of the "Style" => "stle" variable value:

Please Login or Register  to view this content.

[jonathanramey]

That worked for me. I was initially hesitant to use the apostrophe because I wasn't sure how it would interact with everything else, but it works just fine. I will also change the variable name as I didn't even know that Style was a name for something else in the program. Thank you!