Table Header Reference Query

Hi,

Am doing a works project and have the code to search a column for a string and retrieve the information in the cells of that row into textboxes on a userform.
Right now its referencing the column number. and this works fine.
Am not savvy enough to be able to reference it the column header instead of the row number. Have tried a couple of ways off Google but with no joy.
I could do with this as I have the single userform for multiple tables on multiple sheets where the columns can differ.
Would someone be able to help me out.
The code am currently using (for the column number) is below. As an example to get me started the first table name is "kiln1tbl" and one header is "material".
Thanks in advance

Formula:

Please Login or Register  to view this content.

Hello El-Paso,

Well you could easily use the same method as for the rows by.

1. define the last column
2. Loop through each column until you get one, Switch the variable place to

Please Login or Register  to view this content.

Tho other way would be to use Objects, so something like

Please Login or Register  to view this content.

Hi MrChulo

Thanks for taking the time to reply.
Am not sure how to set the header text needed on the first example.
The second example works but the problem is setting the srchheader as I have up to 30 columns so it would need an easy way of working it out.
An example I have on another command is

Formula:

Please Login or Register  to view this content.

but Iv tried fitting this into my new code and it doesn't like it.

Hi,

I am not sure I understand. I thought you wanted to look for a specific column, that is, that the column was known for you, I assumed from the userform.

Maybe provide an example of your excel file and show how it works and with a set of inputs, what is the expected outcome...