Share via

VBA Macros String Capacity issue

Anonymous
2017-09-10T10:36:56+00:00

VBA Macros String Capacity is more than 255 but it's not returning the strings bigger than the length of 255

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-09-11T04:25:50+00:00

    Strings in VBA can be 2,147,483,457 chars (2 GB minus 10 bytes for the variable)

    However, when using the text string in the user interface, there are some limitations:

    1. Displaying a text string in a worksheet cell is limited to 32,767 chars.
    2. Displaying a text string in a MsgBox is limited to 1,023 chars.

    Where do you run into the 255 char limit?

    What version of Excel are you using?

    Was this answer helpful?

    0 comments