Identifying combobox options within a form.

Discussion created by pisupportduke on Aug 5, 2011
Latest reply on Aug 8, 2011 by pisupportduke



I have created a form that will appear when a symbol (pump) on my display is clicked. I am trying to get the combobox to have a full list of names of all the people who work at my facility. The purpose of the combobox is to identify who last edited the form. My question is how to I fill the combobox? In visual basic I would click a small arrow on the combobox and enter all of the names that way, but I have not figured it out in VBA. I also have all of the names in excel. I am looking for a way that I can call a row in excel or enter them in manually. Below is an example what my display looks like.


Help appreciated