How do i use a combo box?

[creamer]

I have no idea how to use a combo box, I can enter the options, just dont know how to give them individual commands.

Can anybody help?

[jcouture100]

What exactly do you mean by "...I can enter the options, just dont know how to give them individual commands."

Do you want to know how to put the info into the ComboBox or are you looking at triggering a certain event after a particular value is selected?

if you want to add items to the combobox, then all you have to do is put this into your form_load event.

combo1.additem "Whatever"

and keep doing that untill you have everything that you want. then you have to put some code in the combo1_change event so when you select one of those items, your code will execute. i hope i was of some help.

[Serge]

Correction. You have to use Combobox_Click event to trap when you select items from the list. Change event fires when you type in the textbox of the combobox.

oh yeah, heh i rarely use cboxes so i forget. thanks for correction, i guess.

[creamer]

I'm not sure how to explain what I'm looking for.

Okay, I have created the combobox, inside the combobox I have the options (for the user to select) entered. I used the List option in the preference window to enter the user options.

What I'd like to know is how do I tell the program what I'd like to do with each individual option within the combobox.

Like if my box has "Option1" as one of the choices, I want to know how to tell the program what to do when that is selected.

Thanks a lot!!

This should help

If Combo1.Text = "Option 1" Then MsgBox ("you selected Option 1")

[creamer]

Thanks a lot!!! Really appreciate it, works fine.

[jcouture100]

You could also use a SELECT CASE statement to do the same thing.

strTemp = Combo1.Text
Select Case strTemp
   Case "Option 1"
      'Put your code for option 1 here
   Case "Option 2"
      'Put your code for option 2 here
   Case "Option 3"
      'Put your code for option 3 here
   Case "Option 4"
      'Put your code for option 4 here
   Case Else
      'Put code for any other selection here.
End Select

Hope this helps.