Defining a variable within a sub...

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

aking1987

Is it possible to define a variable, say "cellalphanumber" as "D" a
part of the ELSE within an if then else statement.

So if its ELSE it will define cellalphanumber = D

Can this definition be used within another sub
 
aking1987,
Do you mean:
Dim cellalphanumber As String
If SomeCondition=True Then
cellalphanumber = "Something Else"
Else
cellalphanumber = "D"
End If

NickHK
 
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
Defining a variable within a sub... 1
Defining public/global variables in more than one place 1
Vlookup with mouse over definitions 2
variable doesn't reference correct column 7
Delete defined names with errors using VBA 1
pivot table macro with a filtering variable 3
sharing variables between form and module code 2

Back
Top