Joined
Last Seen
-2 Reputation Points
- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
0% Quality Score
- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 2
- Posts with Downvotes
- 2
- Downvoting Members
- 2
0 Endorsements
Ranked #11.7K
|
Who shall and in which language convert this VBA UDF Code to be applicable for the application forms? [CODE=text]Function Tryme(mycell) mylen = Len(mycell) For j = 1 To mylen mytest = UCase(Mid(mycell, j, 1)) If InStr(1, "AIJQY", mytest) > 0 Then mysum = mysum + 1 ElseIf InStr(1, "BKR", mytest) …
|
|
|
I found one converter and now code VBA function is looking like this in C# (sharp): public object Tryme(mycell) { mylen = Strings.Len(mycell); for (j = 1; j <= mylen; j++) { mytest = Strings.UCase(Strings.Mid(mycell, j, 1)); if (Strings.InStr(1, "AIJQY", mytest) > 0) { mysum = mysum + 1; } … |