Get the last 3 digit number

Bogz17

New Member
Joined
Feb 19, 2019
Messages
11
Hi can someone help me to my project
It is possible to get the last 3 digit number using command button and textbox1 and display the data into other textbox. I wish someone can solve my problem.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,770
Office Version
  1. 2010
Platform
  1. Windows
For example, ...?
 

Bogz17

New Member
Joined
Feb 19, 2019
Messages
11
I have 16 textbox in my userform and textbox 1 are the one that i use to search to get the data. Is it possible to just search the last 3 digit number that i search instead of 6 digit in textbox1?
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,770
Office Version
  1. 2010
Platform
  1. Windows
Code:
right(textbox1.value, 3)

returns the rightmost three characters.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,542
Messages
5,529,438
Members
409,877
Latest member
DDhol
Top