ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,596
- Office Version
- 2007
- Platform
- Windows
I send values from userform to worksheet.
I’m trying to stop mixing up customers of the same name.
When I send files to worksheet the code adds 3 digits to the customers name
Tom Jones 001
Next purchase from Tom Jones will then be saved like Tom Jones 002 etc.
Only thing with the above is are both Tom Jones the same people ??
So as my sheet is mainly saved eBay purchases I also assign to the sheet the customers eBay username.
What kind of code are we talking so it can look at customers name I’m about to save along with there eBay username.
Depending on the answer depends if the same ID is used or another is created for this customer.
I must advise as at present I have not used any ID at all so all my customers saved are like.
Tom Jones 001 002 003 004 005
Where Tom Jones 003 might be a different person to 001 002 004 & 005
So I’m currently checking there name alongside eBay username.
If you need any code etc from how I send from userform to worksheet etc just ask.
Maybe somehow check the customer with username whilst the userform is open before I save to worksheet.
Now sure how the saved name will look in the worksheet.
Like mentioned currently Tom Jones 001 so maybe just add the ID after what’s there so far.
Thanks.
I’m trying to stop mixing up customers of the same name.
When I send files to worksheet the code adds 3 digits to the customers name
Tom Jones 001
Next purchase from Tom Jones will then be saved like Tom Jones 002 etc.
Only thing with the above is are both Tom Jones the same people ??
So as my sheet is mainly saved eBay purchases I also assign to the sheet the customers eBay username.
What kind of code are we talking so it can look at customers name I’m about to save along with there eBay username.
Depending on the answer depends if the same ID is used or another is created for this customer.
I must advise as at present I have not used any ID at all so all my customers saved are like.
Tom Jones 001 002 003 004 005
Where Tom Jones 003 might be a different person to 001 002 004 & 005
So I’m currently checking there name alongside eBay username.
If you need any code etc from how I send from userform to worksheet etc just ask.
Maybe somehow check the customer with username whilst the userform is open before I save to worksheet.
Now sure how the saved name will look in the worksheet.
Like mentioned currently Tom Jones 001 so maybe just add the ID after what’s there so far.
Thanks.