如何在excel宏中匹配字符串通配符模式

我有一个类似的测试

LEFT('F13',2)='F1'

我想把它从左侧匹配改为支持通配符的测试

I want to change it from a left-side match to a test that supports wildcards

'F13'='F?3'

Excel 不支持正则表达式，除了在 VBA 代码中，但我更喜欢这是在宏中完成的.我应该指出，实际测试不是一个简单的字符串，而是单元格引用(这可能很重要，我不确定):

Excel doesn't support regex except in VBA code but i'd prefer this was done in a macro. I should point out that the actual test isn't a simple string, but cell references (this may be important, I'm not sure):

IF(LEFT($DATA.$A$2:$A$1501,LEN($B$3))=$B$3,...

范围实际上根据调用宏的位置计算为单个单元格.$B$3 是用户输入的模式.

The range actually evaluates to a single cell based on where the macro is called from. $B$3 is the pattern input by the user.