|
-
Jul 9th, 2004, 02:35 AM
#1
Thread Starter
New Member
two different subs, same variables
but i have two subs where i need to use the variables from the former sub in the one that comes later.
i declared the variables before any sub starts:
Public time As Integer
Public time1 As Integer
....and so on......
then:
Public timestring As String
Public timestring1 As String
Then the first Sub starts:
Public Sub DatenAnzeigen_Click()
here i set the values for the variables:
time=Workbooks(2).Worksheets("Zeiterfassung").Range("E9")
time1=------------------------------------------------------.Range("E10")
timestring=CStr(time)
timestring1=CStr(time1)
End Sub
Public Sub DatenAnzeigen2()
And here i need to use the variables declared in the former sub.
Have i made any mistakes?
please tell me
thx, alex
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|