Dynamic options in a data entry form, Visual Basic

[UgneG]

Hello,

I am creating a data entry form using Visual Basic in Excel 2010, and I would like to include an option to choose from a selection of key words. The problem is that the list of keywords will be changed constantly. Is there a way to tie in options available in the entry form to a changing list in an Excel sheet? (adding the extra key words in the code direcly is not an option, as there is a danger that it will be messed up by the users)

Is there perhaps another way to enter data that allows the criteria to be changed easily?

(also I should mention this is the first time I'm using VB...)

Thanks!

[OnErrorGoto0]

It sounds to me like a listbox may be what you want as it allows you to use a list stored in a worksheet. You can then alter the list as and when required.