Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Arne,
Others have mentioned the type definition part, but AFAIK declaring the objects as "ByVal" is pointless as all objects are passed by reference, the default. Unless I'm mistaken, but as a quick test : Private Sub CommandButton1_Click() Range("B3").Value = "Initial value" Call TestByValObject(Range("B3")) Debug.Print Range("B3").Value Dim TestStr As String TestStr = "Initial value" Call TestByValStr(TestStr) Debug.Print TestStr End Sub Function TestByValObject(ByVal argObject As Range) argObject.Value = "If really ByVal, you cannot see this change." End Function Function TestByValStr(ByVal argString As String) argString = "If really ByVal, you cannot see this change." End Function NickHK "Arne Hegefors" ... Hello! I have become somewhat unsure of certian things regarding the syntax in vba. therefor I would truly appreciate answers to the following questions: 1) In the beginning of a sub that takes two arguments do you have to write: Private Sub checkReturnDifference(ByVal rng1 As Range, ByVal rng3 As Range) or can you write ....(ByVal rng1, rng3 As Range) 2) When declaring new variables is it necessary to write: Dim i As Integer Dim k As Integer .... or is there a shorter way of doing this? I know that these questions does not seem very important but when you have meny variables then it does actually make a difference. thus, any help appreciated! thank you all very much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF, THEN SYNTAX | Excel Worksheet Functions | |||
Syntax help please | Excel Programming | |||
Syntax help! | Excel Programming | |||
If then syntax | Excel Worksheet Functions | |||
Help with VBA syntax | Excel Programming |