No announcements
Found 2205819 threads
-
0 VotesVBA If statement
I'm looking for the code to do an if statement used two conditionsUnanswered | 1 Replies | 212 Views | Created by Zecapira - Friday, December 15, 2017 9:37 PM | Last reply by Ashidacchi - Friday, December 15, 2017 11:59 PM
-
0 Votes
VBA - IF statement doesn't work
In this example (changed from the uploaded file) "Sheet2" has the codename "Sheet1", so in VBA, it would ...Answered | 3 Replies | 828 Views | Created by SMAALI Achraf - Thursday, July 3, 2014 1:45 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Thursday, July 3, 2014 4:23 PM -
0 Votes
Use IN within VBA If statement
Hello, Is it possible to use the IN condition within a VBA If statement in Access 2013. I've tried. If ...Answered | 2 Replies | 306 Views | Created by DriveEV - Tuesday, August 4, 2015 12:11 PM | Last reply by Imb-hb - Tuesday, August 4, 2015 12:29 PM -
1 Votes
VBA If statement using cells value
I just thought that I should post some points on the basis of my investigation.It may help you if you need go that way. VBA interpreter will not allow it but you ...Answered | 3 Replies | 6029 Views | Created by Mike7952 - Sunday, June 24, 2012 8:51 PM | Last reply by Asadulla Javed - Tuesday, June 26, 2012 3:32 AM -
0 Votes
VBA If Then Statement
When you put a starement after Then, don't use End If Either use: If condition Then ...Answered | 4 Replies | 623 Views | Created by amywolfie - Wednesday, May 7, 2014 6:06 PM | Last reply by .theDBguy - Thursday, May 8, 2014 9:30 PM -
1 Votes
VBA If, Then Statement
Private Sub Worksheet_Change(ByVal Target As Range) 'you do not use Target ? - ok. With Worksheets(1) If .Range("A2") = "0A" AndProposed | 6 Replies | 1781 Views | Created by Coach K - Saturday, December 15, 2012 2:37 PM | Last reply by Coach K - Saturday, March 2, 2013 3:39 PM -
0 Votes
VBA IF statement (Replace Date Value in Range)
You would not be able to do this with simple IF formula in Excel. You need VBA Code, the following would go in a Module, Sub replaceDateProposed | 1 Replies | 599 Views | Created by MatrixUSA - Thursday, April 3, 2014 7:22 AM | Last reply by Paul Eugin Francis - Thursday, April 3, 2014 9:14 AM -
0 Votes
Using a VBA If statement in a Report
Hi I am trying to use an IF statement which works in a form but when I try and run it in a report it come up with the error: Run-time Error ...Answered | 5 Replies | 311 Views | Created by AJCB - Wednesday, September 26, 2018 10:46 AM | Last reply by AJCB - Wednesday, September 26, 2018 3:54 PM -
0 Votes
VBA IF OR statement not executing correctly
Hi All, In my code i am evaluating a cell value with below IF OR statement Sub testes() If ActiveCell.Value <> ...Answered | 2 Replies | 325 Views | Created by zaveri cc - Wednesday, September 16, 2015 8:20 PM | Last reply by zaveri cc - Thursday, September 17, 2015 1:50 AM -
0 Votes
VBA IF THEN Statement Based on Cell Color
Hello, I'm trying to create an IF THEN statement in Excel VBA that will send out an email if certain cells are red. I've tried a few ...Answered | 1 Replies | 20813 Views | Created by Josh Lindell - Tuesday, March 29, 2011 3:20 PM | Last reply by Bruce Song - Friday, April 1, 2011 1:23 PM -
1 Votes
If Statement - VBA
if statement, such as if the button is has not been clicked then display message, if it's been clicked once, then don't display message. Anybody know ...Answered | 2 Replies | 3089 Views | Created by Gert16 - Monday, September 22, 2008 8:02 PM | Last reply by mkruluts - Tuesday, September 23, 2008 4:06 AM -
0 Votes
VBA Newbie. IF Statement Looking Up Todays Date And Returning Multiple Results
'Learner Details'!I4,"Check End Date","AllUnanswered | 2 Replies | 2172 Views | Created by Sam Degg - Wednesday, September 5, 2012 8:57 AM | Last reply by Ben Collier, UK - Thursday, September 6, 2012 10:23 AM -
0 Votes
If Statement - VBA
'your next steps... End Sub So, you were right in needing an If statement to determine if the ...Answered | 11 Replies | 7071 Views | Created by Gert16 - Monday, September 22, 2008 8:50 PM | Last reply by Gert16 - Tuesday, September 23, 2008 7:49 PM -
0 Votes
IF statement Excel Macro (VBA)
Hello, I'm trying to write an IF statement in a macro with VBA so I can run the macro and get the appropriate value in my column. My logic is below but I can't ...Answered | 2 Replies | 1002 Views | Created by CRM-CB - Monday, October 27, 2014 2:56 PM | Last reply by CRM-CB - Monday, October 27, 2014 3:52 PM -
0 Votes
Access 2003 VBA: If Then Else Statement that is not working
Thank you for the response. I was having exact same problem but now resolved following your advice. Can you explain why "if Isnull(Rs!CheckNo) then...." works but "Answered | 3 Replies | 10561 Views | Created by SteveStew - Sunday, July 27, 2008 10:18 AM | Last reply by sirnewansah - Tuesday, May 31, 2011 12:23 PM -
1 Votes
If Statement with Bookmarks - Word VBA
versatile as possible to be available to variables my customers may prefer. SF1Price and SF1Quantity are to be the 2 if statement checks. If the both of them are 0, then ...Discussion | 8 Replies | 636 Views | Created by gtrplyr6283 - Tuesday, July 7, 2020 7:30 PM | Last reply by Graham Mayor - Saturday, July 11, 2020 1:08 PM -
0 Votes
Excel VBA concatenate function with If statement
0) Then r = r &Answered | 6 Replies | 3294 Views | Created by zaveri cc - Monday, March 10, 2014 8:27 PM | Last reply by zaveri cc - Wednesday, March 12, 2014 2:30 PM -
0 Votes
VBA checkbox - AND operator with If statement
need the results sheet for it. Sub Macro1() Range("A1:C2").ClearContents If ActiveSheet.Shapes("check1").ControlFormat.Value = -4146Answered | 2 Replies | 1237 Views | Created by Chaz1010 - Sunday, February 16, 2014 2:24 AM | Last reply by Chaz1010 - Saturday, February 22, 2014 8:45 AM -
0 Votes
Simple VBA Help - If Then Else Statement based on conditions
? Especially you said that again, what does it mean? Are you using a formula or any vba code? If so,what's the formula/code? Best ...Unanswered | 3 Replies | 360 Views | Created by zagab - Tuesday, August 7, 2018 5:51 PM | Last reply by zagab - Saturday, August 11, 2018 8:41 PM -
2 Votes
VBA code to concatenate cells with IF statement
Hello VBA experts! I would like to check in if you can recomend a solution to my macro problem. So I am trying to write a code that will concatenate cells or words if a ...Answered | 2 Replies | 458 Views | Created by IamJackie - Friday, June 16, 2017 9:38 PM | Last reply by IamJackie - Saturday, June 17, 2017 5:09 PM - Items 1 to 20 of 2205819 Next ›
No announcements
