Create a function to return the cell id of found text

[jsmith2094]

HI Everyone,

not sure where to start, I need to create a custom function so that if I want to search for a name, it will return the cell number that the name is located in,

so if John Smith was in A4 it would return number 4 , and if it was joe smith in cell a3 it would return number 3

any ideas ?

 

[Fluff]

Any reason why you want a UDF, this can be done with a simple formula

+Fluff 1.xlsm
	A		C	D	E
1	Name
2	Tom Pearce			Tom Cobley	9
3	Bill Brewer
4	Jan Stewer
5	Peter Gurney
6	Peter Davy
7	Dan'l Whiddon
8	Harry Hawke
9	Tom Cobley
Fluff

Cell Formulas
Range	Formula
E2	E2	=MATCH(D2,A1:A100,0)

 

[jsmith2094]

Any reason why you want a UDF, this can be done with a simple formula

+Fluff 1.xlsm
	A		C	D	E
1	Name
2	Tom Pearce			Tom Cobley	9
3	Bill Brewer
4	Jan Stewer
5	Peter Gurney
6	Peter Davy
7	Dan'l Whiddon
8	Harry Hawke
9	Tom Cobley
Fluff

Cell Formulas
Range	Formula
E2	E2	=MATCH(D2,A1:A100,0)

I need it as a function for some class work ?

 

[Fluff]

In that case what have you tried?

 

[jsmith2094]

In that case what have you tried?

to be honest im not sure how to do it, im new to VBA still learning lol

 

[Fluff]

I'm afraid I don't do other people's homework. I will happily help correct any errors, but that's it.
Also I do not know what you have been taught, so if I gave you a UDF that used stuff you have not been taught, you'd probably get no marks, which doesn't help anybody.