Macro To Find NextAug 18, 2008
I have a sheet where three columns are appearing as City, Assignee Name, Email id.
In macro there is a form with one find button, one combo box for selecting city, two input box> one for assignee name. 2nd for email id,
This code is for combo box but its taking a1 also after clicking on combo box i wanted that the header should not be on combo box after clicking on it-
Private Sub CmbEmpNm_DropButt*******()
ActiveCell.Sort Range("a2"), xlAscending, , , , , , xlGuess, , , xlSortColumns, xlPinYin
EmpRnge = ActiveCell.CurrentRegion.Address
CmbEmpNm.RowSource = EmpRnge
Appart from that for find button the coding is -
Private Sub CommandButton1_Click()....................