Navigating to a certain cell using column and row values

Basically for Column A,B,C and rows 1,2,3.... I have a drop down list for column and row values to choose from. I have a button beside the drop down list so if I choose B and 2 on both drop downs and click the button, I will get navigated to cell B2.

Can this be done via a button macro? Thanks in advance!

I've currently got this code for each of the drop down, but everytime i click on my selection it resets back to column 2/row3.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks a bunch! This is exactly how I wanted it to operate. Funnily enough the freeze view stopped me from navigating to the cells that are adjacent to the freeze view so had to insert an empty column and row.

One last Q. How do I link this action to a button instead of Worksheet_Change? As now everytime I type in the sheet I get moved to the selection. I've attached it to a Button_click but now it returns with the error "Argument not optional". I created a new macro and this sits under a module.

Please Login or Register  to view this content.

My bad - this will only work when you change B1 or B2:

Please Login or Register  to view this content.

If you want to use the code as a macro, just take out the Target part:

Please Login or Register  to view this content.