Quick Excel VBA Question

[Guest 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!

[Guest 3c273]

Re: Quick Excel VBA Question

 

Click on the index tab of VB Help and type string.

Louis

"Danger_Duck" <DangerDuck@discussions.microsoft.com> wrote in message

news:2B279E43-2CDB-4D05-934B-687FEDE00F65@microsoft.com...

> 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!

[Guest Danger_Duck]

Re: Quick Excel VBA Question

 

Touche-thanks!

"3c273" wrote:

> Click on the index tab of VB Help and type string.

> Louis

> "Danger_Duck" <DangerDuck@discussions.microsoft.com> wrote in message

> news:2B279E43-2CDB-4D05-934B-687FEDE00F65@microsoft.com...

> > 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!

>

>

>

[Guest WindPipe]

Re: Quick Excel VBA Question

 

 

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

 

"Danger_Duck" <DangerDuck@discussions.microsoft.com> wrote in message

news:2B279E43-2CDB-4D05-934B-687FEDE00F65@microsoft.com...

>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!