Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » IF statements within Excel VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
IF statements within Excel VBA
Resolved · Medium Priority · Version 2003
Reply Fri 11 Mar 2011, 15:34Delegate Stephen said...
Stephen has attended:
Excel VBA Intro Intermediate course
IF statements within Excel VBA
In the below example please could you explain why I need to declare the variable as 3 if the following statement works without having 3 in the cell range (ie I have left it blank yet still returns yes,no).
My understanding was that this will only perform if x=3
Sub ifthen()
Dim x As Integer
x = 3
If x = 3 Then
Cells(1, 1).Value = "Yes"
Cells(1, 2).Value = "Please"
End If
Thankyou
For upcoming training course dates see: Pricing & availability
RE: IF statements within Excel VBA
Hi Stephen, thanks for your query. It's a little unclear what you're trying to achieve there, I'm afraid. Could you give me a bit more information? Are you testing the value of the cell on the worksheet, and depending on whether it contains 3 outputting Yes & Please strings? If you are, then your code needs to test the cell value, not a variable value.
Anthony
Tue 22 Mar 2011: Automatically marked as resolved.
|