multiple decsions 
Author Message
 multiple decsions

I have a form which contains optionbuttons 1,2 & 3
depending on which is selected, determines which sub runs.

The scenario is this:

If OptionButton1 selected:

ComboBox1 is populated with 8 items from column A
Item 1 selected in ComBoBox1 populates Combobox2 with column C items
or..
Item 2 selected in ComBoBox1 populates Combobox2 with column D items
and so on

The above is repeated with different data for Options 2 & 3 when selected.

I then need to take the selected values for use later in my macro.

I've been experimenting with addItem and Select Case but cannot complete the
task
a code snip follows..

Private Sub OptionButton1_Click() ' product
ComboBox1.Clear
ComboBox2.Clear

If OptionButton1 = True Then
ComboBox1.AddItem "TR 1 Inva-sert"
ComboBox1.AddItem "TR 2 Broach-sert"

'If TR1 selected, populate Combobox4 with thread options from column B.

   Select Case ComboBox1.Text

   Case "TR 1 Inva-sert"
       ComboBox2.RowSource = "Sheet1!B1:B8"
   Case "TR 2 Broach-sert"
       ComboBox2.RowSource = "Sheet1!C1:C8"

End Select
End If

End Sub

Any ideas welcome



Thu, 08 Jul 2004 20:00:08 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. New article on OE multiple addresses, multiple Identities and multiple User Accounts

2. Multiple Accounts, Multiple Mailboxes

3. Multiple e-mail accounts + multiple inboxes

4. Multiple accounts, multiple signatures

5. Multiple emails received when multiple recipients selected

6. Outlook multiple users without multiple profiles

7. multiple accounte multiple signatures

8. Multiple Users in Win2K - multiple email accounts?

9. Multiple folders, multiple users

10. How to add multiple birthdays to multiple users in calendar


 
Powered by phpBB® Forum Software © phpBB Group