Hi all,
This solution is given by Izandol and works perfectly.
Please refer to http://www.excelforum.com/excel-prog...ith-table.html
I now want to find out if we can populate computername when excel file is opened, then
Compare the computer number with its location from table
Then populate this location in the inputbox heading like “your location is XYZ"
Sample file is attached
Is it possible??
many thanks
Kind regards
Bookmarks