HELP ME
I want to use more than one condition in Left(Cells(1, 1), 2) <> "HE". e.g., here I have used "HE" but I want to use "SE" along with "HE" and I have used Or function but it is giving an error, please help!!
Below is my code:
Please Login or Register to view this content.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. As you are new, I have done it for you today.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thisneeds to bePlease Login or Register to view this content.Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you, It worked
quick follow up question, if I want to use many letters, e.g. "HE" "SE" "IN" "US" "RA" "UK", then this code will become too big.
Is there any short code or any shortcut?
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Try this:
PHP Code:Sub test()
Dim a As String
a = Left(Cells(1, 1), 2)
If InStr("HE|SE|IN|US|RA|UK", a) = 0 Then MsgBox ("Condition Is True") Else MsgBox ("Condition Is False")
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks