in order to keep from repeating youreself (a worth objective) you shoul
instead create a Sub procedure in a Module that accepts the name of th
combobox as an argument. For example:

Public Sub CmbStuff(name As String)

Blah blah blah...

End Sub

Call it from your code as follows:

CmbStuff "ComboboxName1"

or

name = "ComboboxName"
CmbStuff nam

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