Hi,
i wonder how I can case for ex. x twice? Right not I have the script:
Function Namex(Ex)
Select Case Ex
Case A
Namex = "Albert"
Case B
Namex = "Bernard"
Case C
Namex = "Cris"
Case D
Namex = "David"
End Select
End Function
For example I want to:
Case A
Namex = "Albert" And Namex = "Avery"
Each Case A = Albert and Avery
Thnx in advance!
Hi, VBA-NOOB,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
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, it also maintains VBA formatting.
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
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi,
i wonder how I can case for ex. x twice? Right not I have the script:
For example I want to:
Please Login or Register to view this content.
Thnx in advance!Please Login or Register to view this content.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks