I have a user form which has a number of buttons on it. Each button represents a vegetable (Eg, Cucumber, Carrot, Tomato)

The purpose of this is to take orders from customers for the vegetable they would like to order and the amount.

When each button is clicked (eg, Carrot) the macro would place the word 'Carrot' on the excel sheet. After which an input box will appear for the user to input the amount needed.
...