translate ws formula to vba code

  • Thread starter Thread starter L Scholes
  • Start date Start date
L

L Scholes

Can someone please translate this worksheet formula to vba code?

=NameList,INDEX(NameColumn,MATCH(A2,BadgeColumn,0))

The formula does what I need it to do, but I am trying to create a
userform with comboxes and need the second combobox to do this based on
information supplied in the first combobox.

Thank you in advance!
 
Activesheet.Evaluate("=NameList,INDEX(NameColumn,MATCH(A2,BadgeColumn,0))")

either that or use FIND to find A2 in BadgeColumn, then pick up that cell in
NameColumn. What is NameList?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
I am trying to create two dependant comboboxes on a userform, cboOff
and cboNam. I currently have a data validation cell on my worksheet
with BadgeList as the named function to populate that list. Then, in
A2, I have the formula above to supply the name of the officer (from
NameList) with that badge number. I am trying to transfer over to
UserForm to get the same thing, I just can't get the comboboxes to be
dependant on one another???
Thank you!
 
Back
Top