Refresh Problem

[Robert Couchman]

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

 

[BrianB]

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
'----------------------------------------------------