Find Call procedure code within module list

[ipbr21054]

I wish to find where the code is for Call procedures.

For these Example.

@RoryA I did look through some old posts but didnt find what you advised.
Something like but isnt Shift Control F5 etc etc,please advise again & this time i will make a note of it Thanks

Private Sub UserForm_Initialize()
Application.ScreenUpdating = False
On Error GoTo End_here
Call add_val("LOST")
Call add_val("DELIVERED NO SIG")
Call add_val("RETURNED")
Call add_val("UNKNOWN")
End_here: Application.ScreenUpdating = True
End Sub

 

[RoryA]

add_val takes one text argument. It then looks for that text in columns A:G on the Postage sheet and if found, adds the row data to Listbox1. (it seems badly coded to me as it searches 7 columns but uses a fixed offset to return data from that found row, so you could end up with all sorts of data and/or errors)

That code calls the same function 4 times, searching for a different value each time. I have no idea what you think the connection to Module51 is.

 

[ipbr21054]

Module 51 is just where the arrow was pointing.
I was just refering to the Modules in question.

The code should just look in column G as that is where the below is.
LOST, DELIVERED NO SIG, RETURNED, UNKNOWN

 

[RoryA]

If you put the cursor in the word add_val and press Shift+f2 it should take you to wherever the add_val function code is.

 

[ipbr21054]

It takes me to the procedure mentioned above BUT looking in that code who does it now what to look for ?
So see my issue or what im on about

 

[RoryA]

Like I said, it looks for whatever value was passed to it when it was called.

 

[Alex Blakenburg]

See if this helps:

 

[ipbr21054]

Not sure what that is telling me but i was looking for the code in the Call as advised to see if the issue with date in listbox was there.
You advice solved the issue so basically that then ends this post.

Thanks

 

[RoryA]

What Alex was showing you is that each time you call the add_val function, the text you pass ("LOST", "RETURNED" etc) is represented by the variable A in the code. So in your first call above, A has the value "LOST"; in the second call it has the value "DELIVERED NO SIG" and so on.

 

[ipbr21054]

What Alex was showing you is that each time you call the add_val function, the text you pass ("LOST", "RETURNED" etc) is represented by the variable A in the code. So in your first call above, A has the value "LOST"; in the second call it has the value "DELIVERED NO SIG" and so on.

OK i now understand that but still lost when you said its checking 7 columns.
In the code it shows G so i thought it is only looking in column G so confused when you said 7

 

[RoryA]

Your range to search (r in the code) goes from A2183 to the last row in column G.