How can I use values in two separate cells to select a new cell?

I am using two user form list boxes to return values in two separate cells
(the cell link). I want one cell to correspond to a row, the other to a
column. I want a macro button that will automatically select the cell
corresponding with the values listed in the two cell links. Can anyone help?
Thanks.

Hi,

Is this what you want? This is for a button using the FORM toolbar
which calls macro "Button1_Click":

Sub Button1_Click()

Dim r as long, c as Integer

With Worksheets("Sheet1")
r = .Range("a1") ' Link cell for first listbox - row
c =. Range("b1") ' Link cell for second listbox - column
. Cells(r, c).Select
MsgBox ActiveCell
End with

End Sub


HTH

"nassetr" wrote:

> I am using two user form list boxes to return values in two separate cells
> (the cell link). I want one cell to correspond to a row, the other to a
> column. I want a macro button that will automatically select the cell
> corresponding with the values listed in the two cell links. Can anyone help?
> Thanks.