Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining a variable within a sub...
Code ------------------- Sub EXAMPLe Dim cellalphanumber As String If SomeCondition=True Then EXAMPLE1 cellalphanumber = "E" Else EXAMPLE1 cellalphanumber = "D" End If END SUB SUB EXAMPLE1 msgbox cellalphanumber END SU ------------------- can you see where my problem is -- aking198 ----------------------------------------------------------------------- aking1987's Profile: http://www.excelforum.com/member.php...fo&userid=1539 View this thread: http://www.excelforum.com/showthread.php?threadid=27731 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining a variable within a sub...
aking1987,
No, what is your problem ? NickHK "aking1987" wrote in message ... Code: -------------------- Sub EXAMPLe Dim cellalphanumber As String If SomeCondition=True Then EXAMPLE1 cellalphanumber = "E" Else EXAMPLE1 cellalphanumber = "D" End If END SUB SUB EXAMPLE1 msgbox cellalphanumber END SUB -------------------- can you see where my problem is? -- aking1987 ------------------------------------------------------------------------ aking1987's Profile: http://www.excelforum.com/member.php...o&userid=15393 View this thread: http://www.excelforum.com/showthread...hreadid=277313 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining a variable length area for output. | Excel Discussion (Misc queries) | |||
defining a variable-size worksheet area for charting | Excel Worksheet Functions | |||
Defining UserForm Caption from a Variable | Excel Worksheet Functions | |||
Defining a variable within a sub... | Excel Programming | |||
Defining a Variable | Excel Programming |