Excel Cursor point move to a certain cell

[Maggie28]

Hi everyone!
I'm working on a file that has a table to be filled. In order to facilitate the work I've created two combo boxes (correponding to the columns (cell D3) and rows (cell B3) heads) and then with the formulas hlookup and vlookup I've found the cell that corresponds to the match of column and row selected on combo box (cell F3). Now I want to create a button so that when we clicked on it the excel cursor will move to the cell that is calculated on cell F3.
Can you please help me?

 

[Fluff]

Hi & welcome to MrExcel.
How about

Sub Maggie()
   Range(Range("F3").Value).Activate
End Sub

 

[Maggie28]

Hi & welcome to MrExcel.
How about

Sub Maggie()
   Range(Range("F3").Value).Activate
End Sub

Thank you! It worked!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Maggie28]

I have another question. If I want to move the excel cursor point to a specific cell on another sheet, based on the formula of cell F3 (supose that instead of "D8" the cell is filled with "Sheet1!D8"), what do I have to do?
I've tried the same VBA code but it didn't worked.

 

[Fluff]

How about

Sub Maggie()
   Application.Goto Range(Range("F3").Value)
End Sub

 

[Maggie28]

It doesn't seem to work... The following error appears:

 

[Fluff]

Did you copy/pate the code, or type it out?
Also are you running that code on it's own, or part of a larger macro?

 

[Maggie28]

I copy/pasted the code but I changed thi initial part (Sub Maggie()) and I'm running the code on it's own.

 

[Fluff]

I can get a "Method Range of Object _Global failed" error, but not the one you are getting, so not entirely sure what the problem is.
A few possibilities
1) is the sheet name correct?
2) is the sheet protected?
3) is the destination cell merged?