Kingchaos64
New Member
- Joined
- Jan 15, 2021
- Messages
- 46
- Office Version
- 365
- Platform
- Windows
I have a UserForm2 with 3 textbox columns.
'Claim Check, City, Employee Int'.
Is there a way to make the City and Employee textboxes auto populate with the City and Employee that was entered right above it?
Claim Check textbox (Name) starts at c1 the one below it is c2 and so on. City textbox is s1 the one below it is s2 and so on and Employee is e1 and below is e2.
I attached a photo of an example of what I would like to see when I enter the first set of data.
Just trying to make this a faster data entry. Claim checks will always change but city and Employee will only change a bit.
'Claim Check, City, Employee Int'.
Is there a way to make the City and Employee textboxes auto populate with the City and Employee that was entered right above it?
Claim Check textbox (Name) starts at c1 the one below it is c2 and so on. City textbox is s1 the one below it is s2 and so on and Employee is e1 and below is e2.
I attached a photo of an example of what I would like to see when I enter the first set of data.
Just trying to make this a faster data entry. Claim checks will always change but city and Employee will only change a bit.