Sue,
I have created a VBA program that does pretty much what I want to do in
terms of reading data from Excel into a (4,30) array and then filling the
list box in a VBA test form that contains no controls but the list box.
However, I am trying to refine the code by studying the properties for the
list box object and can't find answers to following questions:
1) When Column Heads is selected to True, how do I make the first row of
data from the spreadsheet range appear in the Column Heads? I see the boxes
for the Column heads appear in my filled list but can't figure out how to
populate them. Instead the first row of data from the spreadsheet appears as
the first check box row in the list.
2) The Excel spreadsheet is a log that will have new records/rows placed
into it over days or months by the user, with only a couple of rows
initially. I have a unique requirement to retain the check boxes that were
previously set in the list box by the user without over writing them when the
form is intialized at a later time and the code is then triggered to update
the list from the spreadsheet. Is there some way via code to freeze or lock
the state of check boxes for all 30 rows during the update and then let the
user check any new entries after the update? My requirement is to keep
earlier rows that were in the spreadsheet and only add new ones that weren't
there before when an Intialize triggers an update from the spreadsheet.
3) Is Initalize the best event for me to use to trigger the code to update
from the spreadsheet? My requirement is for the latest spreadsheet data to
always appear when the user opens a custom contact, custom appointment, or
custom Task Request and I just presumed Initialize would be the best choice.
4) Once I get this code exactly the way I want it, how can I insert it into
my custom form that I created with the Design Tool to fill the list box in it
each time the selected event triggers it? Since the code is VBA not VBscript
I don't know how to insert it or modify it to VBscript and I don't want to
take the time to use VBA to create the same custom form I already did via the
Design Tool.

--
John E.