Create a userform that finds a cell address based on 2 input boxes

Hello,

I am trying to create a Userform that would search a sheet based on the 2 inputboxes. I would like to search a specific column for one input box, then the column for the second inputbox. Where the 2 coordinates intersect, i would like to select that cell and input a value based on a 3rd selection. I am pretty new to VBA, but im sure this is a fairly simple task to complete.

any help on this would be much appreciated!

EX:
[TABLE="width: 240"]

[tr]

[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]A[/TD]
[TD="width: 64, bgcolor: transparent"]B[/TD]
[TD="width: 64, bgcolor: transparent"]C[/TD]
[TD="width: 64, bgcolor: transparent"]D[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$1.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$4.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$7.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$10.00[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$2.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$5.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$8.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$11.00[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$3.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$6.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$9.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$12.00[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$4.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$7.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$10.00[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]$13.00[/TD]

[/tr]

[/TABLE]

I'd like to input "B" into 1 input box and "2" into the second input box and have the userform select the "$5.00"cell.

Re: Create a userform that finds a cell address based on 2 input boxes

Quote from fredlo2010;696267

Hello,

Maybe something like this will help

Code

Function InputBoxSolution()
     
    Dim lRow As String
    Dim lcol As String
     
ColumnEntry:
     ' First input box
    lcol = TextBox1("Enter the Column Letter", "Column Input")
     ' Check thats a letter 3 in legth, a letter and not empty
    If Len(lcol) > 3 Or Not lcol Like "[a-zA-Z]" Or lcol = vbNullString Then GoTo ColumnEntry
     
RowEntry:
     ' First input box
    lRow = TextBox2("Enter the Column Letter", "Column Input")
    If lRow = vbNullString Then GoTo RowEntry
     
     ' Select the cell
    Range(lcol & lRow).Select
     
End Function

Display More

Thanks

Display More

Thank you for the input fredl02010, i am getting an error saying:
Compile error: Sub Or function not defined at line:
Icol = textbox1

Also, does this function search a specific column? I have a user ID in the column, and Dates in the row. So, textbox1 would have a user ID and textbox2 would have a date.