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

This example uses a workbook name from one combobox [which is updated
via Sub ResetBookCombo()] called from the Form_Initialize) to update
another combobox with a list of the sheets it contains. Hope this
helps.

'--------------------------------------------------
Private Sub BookCombo_Change()
FindInBook = FindForm.BookCombo.Value
ReSetSheetCombo
End Sub
'--------------------------------------------------
Sub ReSetSheetCombo()
FindForm.SheetCombo.Clear
For Each ws In Workbooks(FindInBook).Worksheets
FindForm.SheetCombo.AddItem (ws.Name)
Next
End Sub
'----------------------------------------------------


---
Message posted from http://www.ExcelForum.com/