I have a listbox which contains a set of values. Now there is a field related to what I select in listbox.
I want to display content of that field in text box even when the field is not selected.
Eg. Suppose I have a filed 'A' and corresponding to that there is a record in field 'B'. Now when I select data in field 'A' i see all the data related to it.However I want to display the data of field B in a text box in other sheet when I select data in field 'A'.