| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA help to test the activecell.value
As you are new to VBA, you still have time to learn good practices and
unlearn bad ones. Try to avoid GoTo statements, and instead structure your code with conditional statements (e.g., the If statement) and/or by calling other procedures. GoTo in nearly universally avoided by professional programmers. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Marie" wrote in message ... I am new to VBA macro's and can not get the following test to work Range("I4").Select If ActiveCell.Value = "W" Then GoTo WVEnumber If ActiveCell.Value = "G" Then GoTo BIGnumber If ActiveCell.Value = "F" Then GoTo BIFnumber The Macro branches to WVEnumber - no matter what is in the cell "I4" - can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you help test our Excel test? | Excel Discussion (Misc queries) | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format | Excel Programming | |||
| Test if ActiveCell is within a certain named range | Excel Programming | |||
| Excel VBA - use of ActiveCell.FormulaR1C1 | Excel Programming | |||
Hybrid Mode
