Hello all,

i have a userform that has alot of comboboxes on.
first combobox is date selection (when this is clicked it
updates 6 textboxes on the form that contain times).

i now have a date and a time, how do i get the form to
automatically put the data relating to this into the
comboboxes?

*================================================= ====*
* <----combobox1----- *
* *
* <-time- <-combobox2-- <-combobox3-- *
* <-time- <-combobox4-- <-combobox5-- *
* <-time- <-combobox6-- <-combobox7-- *
* <-time- <-combobox8-- <-combobox9-- *
* <-time- <-combobox10- <-combobox11- *
* <-time- <-combobox12- <-combobox13- *
*================================================= ====*

**note there are two columns of comboboxes, the value
determaning which column the record should appear in is
located in column "AZ"**

BUT THE MAIN QUESTION IS HOW DO I GET IT TO AUTOUPDATE???
i used a change() function on combobox1.

Thank you,

Robert Couchman