I have a text of 1500 charachtars. How do I store it in a VBA variable

**kbdb** · 12-13-2017, 12:37 PM

I have a text of 1500 charachtars. I want to store it in a VBA variable
A "string" data type can contain up to 2 billion charahtars but I dont how to use it. I have a long text(1500 characters). But when defining my variable it gets cut of after first 255 charachters. How do I make my string contain 1500 charachtars?
Here's my code

sub test ()
dim tmp as String
tmp = " my long text string of roughly 1500 charachters "
end sub

I have also tried:

sub test ()
dim tmp as String * 1500
tmp = " my long text string of roughly 1500 charachters "
end sub

Or maybe I should use another data type than string?

**ImranBhatti** · 12-13-2017, 12:52 PM

why not putting that variable into a cell and then make your string variable equal to that cell.

Please Login or Register  to view this content.

**Special-K** · 12-13-2017, 12:57 PM

What did you do to prove it gets cut off at 255 characters?

This

Please Login or Register  to view this content.

produces a messagebox of at least 80 rows of 10 characters, that's 800 characters for a start.

**Arkadi** · 12-13-2017, 01:01 PM

Hi Kbdb, when you say it is cut off after 255 characters, what exactly do you mean? A textbox would cut it off (I believe), but the string itself should actually contain the full 1500 characters.

As a test, add a line of code that puts the string into a cell A1 for example, and then in another cell make put the formula "=Len(A1)" It should return 1500?

I have a text of 1500 charachtars. How do I store it in a VBA variable

LinkBack

Thread Tools

Rate This Thread

Display

I have a text of 1500 charachtars. How do I store it in a VBA variable

Re: I have a text of 1500 charachtars. How do I store it in a VBA variable

Re: I have a text of 1500 charachtars. How do I store it in a VBA variable

Re: I have a text of 1500 charachtars. How do I store it in a VBA variable

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Store text as variable between two words in Word from Excel VBA

How to store a value of a variable so that it can be used later ?

[SOLVED] Store RGB(x, y, z) As Variable

[SOLVED] Store variable in worksheet and use that variable in VBA code

text box input to store as a variable?

store variable

How to store text to variable

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions