LarryLaser
New Member
- Joined
- Apr 5, 2006
- Messages
- 9
Hey Folks
I am Building a Grade Book for my Wife, that can do everything she needs it to do (big Project). And I ain't no Master coder.
I am working with named ranges, not real knowledgable yet .
I have a "UserForm1" ("UF1") that initalizes when a cell is selected (Range.Name("Pic"), The "UF1" is MultiPage (2), page1 has 1 "TextBox1" and 3 CommandButtons.
Here is my Question.
When the "UF1" Initalizes, I need the "TextBox1" to be populated from 2 cells in the same row as the selected cell but 2 different named ranges. The formula would be like this "=CONCATENATE('Student Info'!D10," ",'Student Info'!C10)", Range C8:C43 = "StudentLast" and D8:D43 = StudentFirst.
Then I want the "TextBox1" to populate the selected Cell after clicking on CommandButton1. This I can handle
If you would Like I can attach a copy of the porject.
Any help with my project would be appreciated.
I am Building a Grade Book for my Wife, that can do everything she needs it to do (big Project). And I ain't no Master coder.
I am working with named ranges, not real knowledgable yet .
I have a "UserForm1" ("UF1") that initalizes when a cell is selected (Range.Name("Pic"), The "UF1" is MultiPage (2), page1 has 1 "TextBox1" and 3 CommandButtons.
Here is my Question.
When the "UF1" Initalizes, I need the "TextBox1" to be populated from 2 cells in the same row as the selected cell but 2 different named ranges. The formula would be like this "=CONCATENATE('Student Info'!D10," ",'Student Info'!C10)", Range C8:C43 = "StudentLast" and D8:D43 = StudentFirst.
Then I want the "TextBox1" to populate the selected Cell after clicking on CommandButton1. This I can handle
If you would Like I can attach a copy of the porject.
Any help with my project would be appreciated.
by xld @vbaexpress.com (Bob) Great Writer
Code:Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) 'needs to target Range Name "Pics" If Not Intersect(Target, Range("Pics")) Is Nothing Then ViewPicture Target.Value End If