While searching I found this link
https://www.mrexcel.com/forum/excel...workbooks.html?highlight=useing+vba+link+cell
But trying to using I am still getting error messages. I tried to just change the path used in this link but with no success
What I am trying to do is have a cell display a value based off of number linked in another workbook.
Example: TextBox (named Names1 will have name entered of a person who receives scores based on multiple performances) On the spreadsheet where the averages are figured (in cell N26) I want the user form to display this average with each score this person receives.
The Current path is "x:\Tracking\Indiviuals\2018 Individuals\[SchJ.xlsx]SchJ'!N26"
So if Names1.Value = Joe Schmoe TexBox2.Value should show the average of each score posted. The spreadsheet already shows the average I just need to link N26 to TexBox2 so it displays on the form. That way as the average changes on the spreadsheet so will the value inside the Textbox2. I can do this on the spreadsheet itself but Joe Schmoe doesn't see the spread sheet they only see the result of the test. Any thoughts? Your help is greatly appreciated.
https://www.mrexcel.com/forum/excel...workbooks.html?highlight=useing+vba+link+cell
But trying to using I am still getting error messages. I tried to just change the path used in this link but with no success
What I am trying to do is have a cell display a value based off of number linked in another workbook.
Example: TextBox (named Names1 will have name entered of a person who receives scores based on multiple performances) On the spreadsheet where the averages are figured (in cell N26) I want the user form to display this average with each score this person receives.
The Current path is "x:\Tracking\Indiviuals\2018 Individuals\[SchJ.xlsx]SchJ'!N26"
So if Names1.Value = Joe Schmoe TexBox2.Value should show the average of each score posted. The spreadsheet already shows the average I just need to link N26 to TexBox2 so it displays on the form. That way as the average changes on the spreadsheet so will the value inside the Textbox2. I can do this on the spreadsheet itself but Joe Schmoe doesn't see the spread sheet they only see the result of the test. Any thoughts? Your help is greatly appreciated.