Need Data type to declare a Variable

[Karthik Sen]

Hi,

I am creating a VBA Code, in which the output values have mulitple double quotes in it , like,

id (1) = create users "/" and/or "notify change"
id (2) = modify users "and"/"or"

I tried declaring the above values as String variables, however due to the presence of several double quotes, its throwing an error.

Kindly advice me on the correct data type to used for the above scenario

[Richard Buttrey]

Hi,

Can you clarify what the references after the = signs are. I'm assuming the id variable is an array.

[LJMetzger]

Hi,

Try one of the following. If you want a 'double quote' inside a string you have to double up (i.e. put 2 double quotes consecutively). Alternately you can use chr(34) which is the equivalent of ONE 'double quote'.

Sub QuotesGalore()

  Dim id(1 To 2) As String
  
  Dim Q As String
  Q = Chr(34)          'Single Double Quote

  'Original text
  'id (1) = create users "/" and/or "notify change"
  'id (2) = modify users "and"/"or"

  id(1) = "create users ""/"" and/or ""notify change"""
  id(2) = "modify users ""and""/""or"""
  MsgBox id(1) & vbCrLf & id(2)

  id(1) = "create users " & Chr(34) & "/" & Chr(34) & " and/or " & Chr(34) & "notify change" & Chr(34)
  id(2) = "modify users " & Chr(34) & "and" & Chr(34) & "/" & Chr(34) & "or" & Chr(34)
  MsgBox id(1) & vbCrLf & id(2)

  id(1) = "create users " & Q & "/" & Q & " and/or " & Q & "notify change" & Q
  id(2) = "modify users " & Q & "and" & Q & "/" & Q & "or" & Q
  MsgBox id(1) & vbCrLf & id(2)


End Sub

Lewis

[mikerickson]

In explicit strings, VBA uses a double quote for a quote mark.

Dim myVar as String

myVar = "This is outside quotes. ""Inside q marks"" Outside."

MsgBox myVar