Defining a variable within a sub...

  • Thread starter Thread starter aking1987
  • Start date Start date
A

aking1987

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defining a variable within a sub... 1
A problem with creating a workbook by VBA 3
Some trouble assigning a string to a variable 22
VBA set thick borders around non empty cells in range 0
Get rid of need for F2.Select 3
How to hide password? 1
Copy Multiple Workbooks to Worksheet 2
Way to only import new files? 22

Back
Top