Guest Danger_Duck Posted July 30, 2008 Posted July 30, 2008 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 Posted July 30, 2008 Posted July 30, 2008 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 Posted July 30, 2008 Posted July 30, 2008 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 Posted July 30, 2008 Posted July 30, 2008 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!
Recommended Posts