KentBurel
Board Regular
- Joined
- Mar 27, 2020
- Messages
- 68
- Office Version
- 2019
- Platform
- Windows
I have a snippet of a bigger spreadsheet that looks like this
The problem is quite simple. I want to enter a 7 digit seal number where the first 4 digits are the same. So instead of having to enter all 7 digits, I want to only enter the last 3 and have the 4 digit prefix automatically prepended. And I need to do this in the same cell. So when the user clicks on a blank cell C2 and enters 123, I want that cell to prefix it with 0543 (or whatever the current prefix is) and store that value in cell C2. I don't want the E and F columns. This is part of a larger VBA project so I don't have to use formulas, I can use VBA code as well.
Thank you for your help.
The problem is quite simple. I want to enter a 7 digit seal number where the first 4 digits are the same. So instead of having to enter all 7 digits, I want to only enter the last 3 and have the 4 digit prefix automatically prepended. And I need to do this in the same cell. So when the user clicks on a blank cell C2 and enters 123, I want that cell to prefix it with 0543 (or whatever the current prefix is) and store that value in cell C2. I don't want the E and F columns. This is part of a larger VBA project so I don't have to use formulas, I can use VBA code as well.
Thank you for your help.
Last edited by a moderator: