Excel Cursor point move to a certain cell

Maggie28

New Member
Joined
Nov 26, 2020
Messages
7
Office Version
  1. 365
Platform
  1. Windows
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?

1606391283551.png
 
For questions 2) and 3) the answer is no. Regarding question 1), are you refering to the sheet name on the cell F3? If so, yes I confirmed it is correct.
Maybe I'v done something wrong in the process. I've selected View Code:
1606419822360.png

And then I copy the code you told me to try and run it:
1606419871861.png

Did I skip some step?
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You need to put the code in a standard module, rather than in a Sheet module.
Also is the sheet name in F3 that same as the text in brackets in you image? So is it Sheet1!D8, or 1T!D8
 
Upvote 0
You need to put the code in a standard module, rather than in a Sheet module.
Also is the sheet name in F3 that same as the text in brackets in you image? So is it Sheet1!D8, or 1T!D8
Thank you! It's working fine now!
I just changed the code to a standard module.
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,214,877
Messages
6,122,051
Members
449,064
Latest member
scottdog129

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top