Can ControlSource refer to cells in a spreadsheet that is not the active window
- In an Excel form can the ControlSource property be used to refer to cells on a worksheet that is not the active window. I have a suite of forms I'm using to update many cells on a separate open workbook but the method I'm currently using to take the values from the form and palce them in the correct place on the worksheet seems cumbersome and I wondered if ControlSource could save a considerable amount of code.
- ПеремещеноJeff ShanMSFT30 ноября 2009 г. 8:26off topic (From:Visual Basic Language)
Ответы
Hi Jimbo,
This forum is for VB.NET questions only (e.g. Visual Basic 2003, Visual Basic 2005, Visual Basic 2008).Sticky: For Visual Basic 6 questions, please read...
Sticky: For VBA, Office (VSTO), Macros and VBScript Questions
For VBA (Visual Basic for Applications), Macros or Excel Questions, you will get better support in the VBA Forum:
http://social.msdn.microsoft.com/forums/en-US/isvvba/threads/
For developing add-ins for Office 2003 or 2007 products:
Visual Studio Tools for Officehttp://social.msdn.microsoft.com/forums/en-US/vsto/threads/
For VBScript questions, you will get better support at related forums to VBScript.
http://www.visualbasicscript.com/ (A Non-Microsoft Site)http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.scripting.vbscript VBScript
Newsgroup DiscussionThanks for your understanding!
Regards
Jeff Shan
Please remember to mark the replies as answers if they help and unmark them if they provide no help.- Помечено в качестве ответаJimbo411 30 ноября 2009 г. 8:44
Все ответы
Hi Jimbo,
This forum is for VB.NET questions only (e.g. Visual Basic 2003, Visual Basic 2005, Visual Basic 2008).Sticky: For Visual Basic 6 questions, please read...
Sticky: For VBA, Office (VSTO), Macros and VBScript Questions
For VBA (Visual Basic for Applications), Macros or Excel Questions, you will get better support in the VBA Forum:
http://social.msdn.microsoft.com/forums/en-US/isvvba/threads/
For developing add-ins for Office 2003 or 2007 products:
Visual Studio Tools for Officehttp://social.msdn.microsoft.com/forums/en-US/vsto/threads/
For VBScript questions, you will get better support at related forums to VBScript.
http://www.visualbasicscript.com/ (A Non-Microsoft Site)http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.scripting.vbscript VBScript
Newsgroup DiscussionThanks for your understanding!
Regards
Jeff Shan
Please remember to mark the replies as answers if they help and unmark them if they provide no help.- Помечено в качестве ответаJimbo411 30 ноября 2009 г. 8:44
