Dear Nasuko
Your solution is available here now,i hope it will work now.
i have rearrange your code now.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''''''
'''''Module1
'''''''''''''''''''''''''''''''''''''''
Option Explicit
Sub macro1()
Dim sht1 As Variant
Dim sht2 As Variant
'Set sht1 = ThisWorkbook.Worksheets("Sheet1")
'Set sht2 = ThisWorkbook.Worksheets("Sheet2")
Set sht1 = Worksheets("Sheet1").Range("b2")
Set sht2 = Worksheets("Sheet2").Range("b2")
MsgBox "" & sht1
MsgBox "" & sht2
'sht2 .Range("A1") = Worksheets("Sheet1").TextBox1.Value
End Sub
'The above code works fine. My question is originally I have the
'following code instead of the last line:
'sht2 .Range("A1") = sht1.TextBox1.Value
'and it does NOT work.
'Does anyone know why?
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Hope It will Help
Happy To Help
:)
Shyam
On Sat, Mar 13, 2010 at 10:12 PM, Sukiyaki <nas...@yahoo.com> wrote:
> Hello,
>
> I want to call value from a textbox control (textbox1) which is placed
> on Sheet1 to a cell in Sheet2. I use the following code to do it:
>
> Dim sht1 As Worksheet
> Dim sht2 As Worksheet
>
> Set sht1 = ThisWorkbook.Worksheets("Sheet1")
> Set sht2 = ThisWorkbook.Worksheets("Sheet2")
>
> sht2 .Range("A1") = Worksheets("Sheet1").TextBox1.Value
>
> The above code works fine. My question is originally I have the
> following code instead of the last line:
>
> sht2 .Range("A1") = sht1.TextBox1.Value
>
> and it does NOT work.
>
> Does anyone know why?
>
>
> Sukiyaki
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Thanks Regards
Shyam
Software Engineer
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
When one door of happiness closes, another opens;
but often we look so long at the closed door that we do not see the
one which has been opened for us.
- Helen Keller
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
