VBA String Array Syntax?

Question

Dim Subjects = New String() {"Health Care", "Tax", "Trade", "Technology and Privacy", "Energy and Natural Resources", "Oversight", "Domestic Issues", "Other"}

Receiving a syntax error, looking for an end to the statement, but as far as I can tell this should be proper syntax?

That's VB.NET syntax (or close to it at least). Are you writing this is VBA or VB.NET? — Comintern
– Comintern, Commented Nov 5, 2018 at 23:00
VBA, because I'm working in Word, but the syntax examples I was learning from were from learn.microsoft.com? Weird that they'd have VB.NET syntax examples. — Sil
– Sil, Commented Nov 5, 2018 at 23:40
VBA can be difficult to search for documentation on via doc.microsoft.com these days. You need to make sure that you don't see .NET in the page header. TBH, you're probably just better off searching here on SO or using a non-MS site for documentation. — Comintern
– Comintern, Commented Nov 5, 2018 at 23:47
You need to learn to use the F1 key. In the VBA IDE put the cursor on a keyword and press F1. This will take you to the MS help page for that keyword. — freeflow
– freeflow, Commented Nov 6, 2018 at 22:54

macropod · Accepted Answer · 2018-11-05 23:10:05Z

2

Dim Subjects()
Subjects = Array("Health Care", "Tax", "Trade", "Technology and Privacy", "Energy and Natural Resources", "Oversight", "Domestic Issues", "Other")

answered Nov 5, 2018 at 23:10

macropod

14k2 gold badges11 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA String Array Syntax?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related