Automatic answer in msgbox based on mapping
Hello,
I'm completely new in the forum, and also quite new to VBA.
I work in HR and have a list of job functions that I need to map according to a table containing financial data. Eg.:
HR job function = Construction
Finance data = 142
HR Job function = Marketing
Finance data = 143
Now, I want to create an input box where my user chose from a drop down list the HR job function. Once the HR job function selected, the corresponding Finance data info should appear in a MSGbox. The mapping of HR job functions and Finance data is all stored in an excel file.
Can anyone help me with a code that could do this? I tried looking around on other forums but didn't find anything that looked like this.
Thanks a mill in advance!
Thanks a lot! That worked
Thanks a lot! That worked wonders :)
See the response post for an
See the response post for an example workbook