combo box

[Michael J. Malinsky]

You could have a macro that called other macros based on the
ComboBox.ListIndex property. Something

Private Sub ComboBox1_Change()
SelectCase ComboBox1.ListIndex
Case0
Name1
Case1
Name1
Case2
Name3
End Select
End Sub

Then create separate Subs called Name1, Name2, etc.

HTH
--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

 

[Zdenka]

Hi,
I have a combo box with, for example, four names. Is it possible to assign a
macro to each name. ( four names - four different macros). I tried, and I
can assign only one macro which can be run from all names.

 

[Zdenka]

Thanks Michael!!!

You could have a macro that called other macros based on the
ComboBox.ListIndex property. Something

Private Sub ComboBox1_Change()
SelectCase ComboBox1.ListIndex
Case0
Name1
Case1
Name1
Case2
Name3
End Select
End Sub

Then create separate Subs called Name1, Name2, etc.

HTH
--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

assign

 

[Zdenka]

Thanks Michael!!!

You could have a macro that called other macros based on the
ComboBox.ListIndex property. Something

Private Sub ComboBox1_Change()
SelectCase ComboBox1.ListIndex
Case0
Name1
Case1
Name1
Case2
Name3
End Select
End Sub

Then create separate Subs called Name1, Name2, etc.

HTH
--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

assign