To manage the option buttons on a VBA userform, use the "option button group" parameter: Enter one name per group of option button, so the program will know which ones are linked.
Showing posts with label link. Show all posts
Showing posts with label link. Show all posts
Sunday, June 19, 2016
Sunday, February 7, 2016
How to go to formulas references in Excel
To access Excel formulas' references of a selected cell, you first need to trace the formula dependents in Formulas tab > Trace Dependents button.
The blue arrows will show the dependent cells:
If there is a dotted arrow it means the cell is linked to another sheet's cell or another file's cell. Double click on the arrow to navigate to the reference cell:
A Go To dialog box will pop up: Select the reference and click OK to jump to that specific cell:
Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD
Subscribe to:
Posts (Atom)