Quick Excel VBA Question

  • Thread starter Thread starter Danger_Duck
  • Start date Start date
D

Danger_Duck

I know this is NOT the best place to ask this, but I figure somebody must know:

Does Visual Basic even have the concept of a string? I'm in Excel's table of
contents "Microsoft Excel Visual Basic Reference" and I don't see string, or
methods I see in online forums such as Split, RightString, LeftString etc...

And is there a newsgroup for VBA questions?

Thanks!
 
Hello Danger_Duck,

Newsgroups;
-microsoft.public.excel
-microsoft.public.excel.programming

They're very handy, and the people there are willing to help.

In VBA, there's not really a string object that encapsulates methods and
properties for that object (unless it's deep into the inner workings of the
language). Using the Excel VBA help file, and IntelliSense you can see the
string functions and fields. These functions for strings are in the VBA
Class in VBA, (poor) examples;

VBA.Right("the string", length)
VBA.Left("the string", length)
VBA.Mid("the string", start_index, [length])
VBA.Len("the string")

..... Many more

- WindPipe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top