Hi All,
Could anyone please help me on below query in VBA?
I have master file where we have lots of data. I want to make a box through user form in which I just put a word and get all the related details in message box. For example. I have attached a Data file in which we have four columns A =Company ID, B=Property ID, C=Location usage, D=Term status.
I want once I open excel and run the macro then one box appear Company ID filed where I can find any of the given id in sheet and get a message box with all other details like PROPERT ID, LOCATION USAGE AND TERM STATUS in message box.
please suggest the code as I am not a regular user of VBA but I am trying to learn it.
Thanks
Ankit Jain
Bookmarks