Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
basically we need variable..............
please find the below links for more information about variable http://www.functionx.com/vbaexcel/Lesson05.htm http://www.ozgrid.com/VBA/variables.htm and your code we need variable but don't need to declare Sub Test2 () x = range("H1").value MsgBox ("Test 2 number : " & x ) End Sub On Aug 12, 11:45*pm, "Swingleft" wrote: Hello, question on how to declare variables. I have something simples like this Sub Test () Dim H1 As Integer H1 = Range("B6").Value MsgBox ("Test number: " & H1 ) End Sub Is there an easy way to use the "H1" value without again having to declare it? Sub Test2 () MsgBox ("Test 2 number : " & H1 ) End Sub -------------------------- thanks for the help again Swingleft |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Declaring Variables | Excel Programming | |||
Declaring Variables Twice? | Excel Programming | |||
Declaring variables | Excel Programming | |||
DEclaring variables | Excel Programming | |||
Declaring variables | Excel Programming |