I am very new at vba and am interested in creating a program that does the following. When a item is selected from a drop down menu it will paste certain text into the cells that are next to the drop down list selected.
For example: My drop down list contains in column A COMMENT MOVE
When I select "COMMENT" I would like to populate in column B "ENTER COMMENT" When I select "MOVE" I would like to populate in Column B "ENTER MOVE TYPE" and in Column C "ENTER MOVE SPEED"
I would only like these to change upon selecting the drop down menu as to I am using this data in cells other cells based upon which drop down menu item is selected.