PDA

View Full Version : Populate form ListBox from range



theta
04-20-2016, 06:57 AM
I am hoping to populate a form ListBox from a range as follows:

1. Number of rows and columns defined by the range e.g. range is 2 columns and 3 rows, the ListBox is populated.

2. When saving (having removed or added data), the range is updated with the contents of the ListBox.

This will contain name, title, address information.

Will this need to fill an array that is then increased/decreased in size based on changes? Add individual, remove individual, edit individual.

Any code examples appreciated!