Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data from excel range to User form in textbox
hi everyone
I have an information in worksheet Sheet1 Cell EA3 I want when I load mu user form in the text box I see the information in cell EA3 Note the value in Cell EA3 is the sum of AA5+AA7+AA8 Conclusion I want to take data from excel to see in text box not transfer data from user form to excel Can someone help please Bakar Last edited by Bakar : October 26th 12 at 03:14 PM Reason: solved |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data from excel range to User form in textbox
hi,
Me.TextBox1 = Sheets("???").Range("EA3").Value -- isabelle Le 2012-10-21 12:11, Bakar a écrit : hi everyone I have an information in worksheet Sheet1 Cell EA3 I want when I load mu user form in the text box I see the information in cell EA3 Note the value in Cell EA3 is the sum of AA5+AA7+AA8 Conclusion I want to take data from excel to see in text box not transfer data from user form to excel Can someone help please Bakar |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data from excel range to User form in textbox
On Sun, 21 Oct 2012 16:11:56 +0000, Bakar
wrote: hi everyone I have an information in worksheet Sheet1 Cell EA3 I want when I load mu user form in the text box I see the information in cell EA3 Note the value in Cell EA3 is the sum of AA5+AA7+AA8 Conclusion I want to take data from excel to see in text box not transfer data from user form to excel Can someone help please Bakar I have a cell which I assign a range name to. I have a text box (shape) where the text is equated to the range name via formula, as in: =NameCall The term "NameCall" is just your range name, not anything else. So if you name your range "Tally1" or whatever, the text box would resolve to "=Tally1" (no parentheses). So, you set your range name, and then place your "shape", as in a text box "rectangle" or oval or whatever shape, and enter the formula, then format the resultant text that appears. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign a range to where the User Form places data | Excel Programming | |||
Automatically add a textbox to a user form based on user requireme | Excel Programming | |||
Textbox on user form in Excel VBA | Excel Programming | |||
macro that takes data entered in a user form textbox to go to a ra | Excel Programming | |||
user form - data range | Excel Programming |