linked cell

  1. F

    Link and update a defined name to an activex textbox

    Hi, I have an activex textbox in sheet1 which should display a text from a linked cell in sheet2, although the text doesn't update as it should. The text should change depending on which value the user types in. The reference is created with a defined name from sheet2, the Offset and the...
  2. F

    ActiveX Text Box not updating

    Hi, I have grouped an ActiveX text box with Excel's box and whiskers chart. I want the text box to update as the data table is filtered. First, I used the Linked Cell -function but it doesn't update the text box when I run my macro. It sorta "reacts" slowly, in a sense that the value of text box...
  3. S

    Linked Textbox not getting update dynamically

    Hi everyone, I created a textbox and linked to the cell if i copy paste the whole row the textbox2 goes the previous linked cell In Row 5 Textbox1 linked to E5 Textbox2 linked to F5 Textbox3 linked to G5 Textbox4 linked to H5 <strike> </strike> Now I am selecting the Row5 and pasting it...
  4. D

    Message Box to linked Cell

    Hey Folks, I am trying to get a pop-up box to appear when a linked cell goes below a certain value.... On the code below cell "S15" is linked to my "Sheet1, cell C5", but when the value of C5 goes below 10, it should display a pop-up, but doesn't. Can anyone help me with the additional code...
  5. E

    Q: How do i keep a row connected together(moving together) while shifting/adding row above it?

    I have an Excel file containing two sheets: - `Teams` (which contains details of teams and time schedule of their matches) - `Results` (contains calculation and number of matches and results, etc). What`Results`did is that each game that has launched status on `Teams` it gets on...
  6. H

    Cell links to a file I can't find in the directory

    I opened an Excel file that's stored in the LAN. A cell in the file is linked to '\\LAN folder\LAN subfolder 1\LAN subfolder 2\Received\[Sheet Name]tab_name'!$A$1. The formula works fine. I wanted to find the source file [Sheet Name]. I went to the LAN folder, then LAN subfolder 1 and LAN...
  7. N

    Relative Cell Reference for a "Select All" Checkbox Macro

    I have a spreadsheet with many checkboxes and a checkbox determines if a row is going to be used in some calculations. Some sections have many rows, and to make it easier to select many row at once, I though it would be a great idea to add a "select all" checkbox. My spreadsheet was "macro...
  8. L

    Checkbox Macro to Identify the Linked Cell of the Checkbox in Excel 2010

    I am attempting to use checkboxes on a worksheet that if checked will increase the value of the cell 3 columns to the right of the linked cell by 10. I have many (>20) checkboxes on this sheet so I want to write one macro that will identify the linked cell of the checkbox clicked and then...
  9. B

    Highlight linked cell

    I want to highlight the cell chosen by a link. I have a list in the first column of my worksheet (in alphabetical order so I can find them) that corresponds to the column headings (inspection types in this case). For example, if I click the link in the first column for "Foundation Inspections"...
  10. A

    Linked Cell

    I have job names that I want to repeat on another sheet. but when I add a row in my source sheet, and add a new job name,the job names in other sheet are not updated. What I want is, when I add a row in source sheet, a row to be added on relative position on the output page and the formulas that...
  11. A

    Obtain the checkbox linked cell address in code

    Hi everyone, I have some code that removes a range of checkboxes (which were inserted using some insert checkbox code). The checkboxes are removed but the linked cells are not cleared. I am trying to modify the code so that the linked cell is cleared. I have made a change that will clear the...
  12. J

    Change linked cell color if value changes

    Basically, I have a workbook with several sheets. Sheet 1 is a "master" sheet and it contains a ton of numeric and text values. The other sheets reference cells from this "master" sheet. This way, a change on the master sheet is reflected in all the other sheets. What I want: When a value on...
  13. P

    Refreshing Linked Cells

    Hi! I have a workbook into which I want to insert worksheets. There is a worksheet (CONSOLIDATED) which will consolidate the data from the other sheets which are inserted on a monthly basis. An example formula (on CONSOLIDATED) is ='RED'!C24 Where RED is the worksheet that will be...
  14. T

    VBA to Link ScrollBar Max to Specific Cell

    Hi Folks, I am trying to link the maximum values of a set of scroll bars (across many sheets in the same workbook) to a range of cells set to display the current maximum value. The maximum value for each scrollbar will change each month, necessitating this update. I have almost 100 scroll...

Watch MrExcel Video

This Week's Hot Topics

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
Top