Is there a way to populate a column based on the contents of multiple columns using VBA in Excel

I am trying to find a way to populate a column in an excel sheet based off the contents of multiple other columns - similar to what I would use a CASE statement for in SQL.

Example

Column A : comment or empty 
Column B: comment or empty 
Column C: comment or empty 
Column D: comment or empty 
Column E: comment or empty 

Column F: column will have a comment based on the contents of the above. IF column A = 'specific comment' THEN fill column F with that comment. IF column B = 'specific comment' THEN fill column F with that comment. IF column C = 'specific comment' then fill column F with that comment and so on.

I have very seldom dabbled in VBA but was curious if there is a way to write this in code?