Case statement won't assign variables

**TyroneBigFoot** · 01-12-2023, 10:08 AM

I have a case statement and I want to assign values to a set of two variables when a condition is met but both my variables are returning zero. can you please help me

Please Login or Register  to view this content.

**ByteMarks** · 01-12-2023, 10:20 AM

You don't need the reference to regExString in each case.

So it should be Case "HA" not Case regExString = "HA"

**TyroneBigFoot** · 01-12-2023, 10:40 AM

Thank you, your a lifesaver

Case statement won't assign variables

LinkBack

Thread Tools

Rate This Thread

Display

Case statement won't assign variables

Re: Case statement won't assign variables

Re: Case statement won't assign variables

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to assign case to staff fairly

[SOLVED] Select Case with multiple lines in a case statement?

[SOLVED] i have an if then statement that works, how to make it work as a with or case statement

VBA assign Variables

[SOLVED] Assign values to case sensitive characters within string

Using Array to define variables for Select Case Statement

[SOLVED] Utilize a Select Case Statement in Target Intersect Statement

Bookmarks

Bookmarks

Posting Permissions