I currently have a meal log that I am working on, what I am trying to do is be able to select a food from a listbox and have the number of Protein, Fat, carbs and Calories appear in the relevant colums next to the food. I have all the food data on sheet2 and at the moment I am struggling to work out how to make proper use of the listbox any suggestions would be greatly appreciated
Cheers