How to use VBA Coding

[Potholes]

Hi all

I wish to learn more about VBA programming, if it is a simple answer.

I have one question, What vba code would you use to to search for the contents of a cell.

Thank you

Peter

[MrShorty]

There's more than one way to find stuff using VBA. Two methods come immediately to mind:
1) Using the Range.Find method: https://docs.microsoft.com/en-us/off...cel.Range.Find which is equivalent to using the "Find" command from the home tab.
2) Calling Excel's lookup functions from VBA: https://docs.microsoft.com/en-us/pre...1(v=office.14).
Which method to use depends on what you want to do once you find the information you are looking for.

[Potholes]

mrshorty AKA ??

Me Peter

along the lines of If cell "X" = " " then Stop " Y " from displaying anything.

[k1dr0ck]

you mean like ex:

Please Login or Register  to view this content.

mrshorty AKA ??

Me Peter

along the lines of If cell "X" = " " then Stop " Y " from displaying anything.

[Potholes]

Good afternoon k1dr0ck

I will try adding on top of of some existing code.

Thanks

Peter

[Potholes]

Greetings and sundry

Owing to the Enduro Exec's moving the goal post, I have to rethink all of my project.

I will sign off that the outstanding 2 current threads are Solved and re-apply for help later
after I have had time to work out the logics.

Peter

[Potholes]

Att Ali

If I may would you mind commenting on what each line does in this coding
so I can look at doing my attack at it please.

Because this is one area I have to manipulate.

Please Login or Register  to view this content.

[AliGW]

You seem to think that I am the fount of all knowledge, which I suppose is flattering. I did not provide the code, so the caveat is that I may have interpreted it incorrectly, however I'll have a go:

Please Login or Register  to view this content.

Have you started to collate a notebook of code snippets with reminders about what they do? If not, then you are not really getting the best out of the help offered here, and will end up coming back and asking the same questions over and over again, which might aggravate (some of) your helpers.