Hi tariqjahangir
Its better to see codes rather than a picture, but i think you might want to use something like these....
Textbox1.value = Activecell.offset(0,1)
You first need to set an "activecell" by searching the sheet for a value which is on the same row as the data you want on those textbox's.
Once your search finds the value, that cell becomes the "activecell".
You can then use the above code to fill the textbox with values left or right of the activecell by changing the (0,1) values to suit.
hope this helps....
Bookmarks