Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Command for VBA in Excel
Good Morning Everyone,
I have a question for you VBA Experts out there. I'm trying to organize data through color coding using the "For Each" loop, and I'm wondering if there is a command that can define a variable? For Example, a product number we have is D0000200, but there is another product number that is D00002001. Both of these products are in the same group, despite having different numbers. I'm wondering if VBA can discriminate (or if there is a code that can act as a variable, such as X in a simple math problem) the "D0000" portion of the code and look expressly at the "200" or "2001" expression? Any help is greatly appreciated!!! ~Fernando, IBT Employee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Command for VBA in Excel
You can certainly write something that says
If ActiveCell = "*2001" then blah blah else if Active Cell = "*200" then blah blah end if If you define the cell that you're looking at as CurrentProduct then you could do something similar such as: If CurrentProduct.Value like "*2001" then blah blah else if CurrentProduct.Value like "*200" then blah blah end if The "*" is a wild card and accounts for anything. Is this what you're looking for? "IBT Employee" wrote: Good Morning Everyone, I have a question for you VBA Experts out there. I'm trying to organize data through color coding using the "For Each" loop, and I'm wondering if there is a command that can define a variable? For Example, a product number we have is D0000200, but there is another product number that is D00002001. Both of these products are in the same group, despite having different numbers. I'm wondering if VBA can discriminate (or if there is a code that can act as a variable, such as X in a simple math problem) the "D0000" portion of the code and look expressly at the "200" or "2001" expression? Any help is greatly appreciated!!! ~Fernando, IBT Employee |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Command for VBA in Excel
Thank you, this is exactly what I was looking for!
"Bob Phillips" wrote: Maybe something like this Select Case Left$(myVariable, 5) Case "D0000" Select Case Right(Mid$(myVariable, 6, Len(myVariable) - 5) Case "200" 'do something Case "2001" 'do something else 'etc. End Select 'etc. End Select -- __________________________________ HTH Bob "IBT Employee" <IBT wrote in message ... Good Morning Everyone, I have a question for you VBA Experts out there. I'm trying to organize data through color coding using the "For Each" loop, and I'm wondering if there is a command that can define a variable? For Example, a product number we have is D0000200, but there is another product number that is D00002001. Both of these products are in the same group, despite having different numbers. I'm wondering if VBA can discriminate (or if there is a code that can act as a variable, such as X in a simple math problem) the "D0000" portion of the code and look expressly at the "200" or "2001" expression? Any help is greatly appreciated!!! ~Fernando, IBT Employee |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Command for VBA in Excel
Yes thank you, both of these replies have clarified the situation greatly.
"StumpedAgain" wrote: You can certainly write something that says If ActiveCell = "*2001" then blah blah else if Active Cell = "*200" then blah blah end if If you define the cell that you're looking at as CurrentProduct then you could do something similar such as: If CurrentProduct.Value like "*2001" then blah blah else if CurrentProduct.Value like "*200" then blah blah end if The "*" is a wild card and accounts for anything. Is this what you're looking for? "IBT Employee" wrote: Good Morning Everyone, I have a question for you VBA Experts out there. I'm trying to organize data through color coding using the "For Each" loop, and I'm wondering if there is a command that can define a variable? For Example, a product number we have is D0000200, but there is another product number that is D00002001. Both of these products are in the same group, despite having different numbers. I'm wondering if VBA can discriminate (or if there is a code that can act as a variable, such as X in a simple math problem) the "D0000" portion of the code and look expressly at the "200" or "2001" expression? Any help is greatly appreciated!!! ~Fernando, IBT Employee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Or Command | Excel Worksheet Functions | |||
Possible to pass a variable to Excel from command line/short cut? | Excel Programming | |||
SUM command using variable sheets | Excel Worksheet Functions | |||
Syntax for Excel variable using a SQL Select/From/Where Command... | Excel Programming | |||
variable 'open' command | Excel Programming |