vba help

  • Thread starter Thread starter work
  • Start date Start date
W

work

what newsgroup would i use for help with VBA in ms-office apps?
i can't find the old SUBSTR function to build strings with.
thank you...
mike
 
Excel applications?

If yes, then there's a .programming newsgroup just waiting for you.

But you may want to look at:

right, left, mid, instr, instrrev
in VBA's help
(instrrev was added in xl2k)
 
Dave said:
Excel applications?

If yes, then there's a .programming newsgroup just waiting for you.

But you may want to look at:

right, left, mid, instr, instrrev
in VBA's help
(instrrev was added in xl2k)
Click to expand...


thanks, i'll look there. but the left, right,instr take data FROM a
string (as i understand them). i need to build a string and insert
things into it.
 
Here is an example



sub AddString
dim strText as string
strText$ = "Hello "
msgbox strText
strText$ = strText & "How Are You Today"
msgbox strText
end sub
 
thanks, i'll look there. but the left, right,instr take data FROM a
string (as i understand them). i need to build a string and insert
things into it.
Click to expand...

D'ya mean

MyString = LEFT(anystring, length) & " a new bit " & RIGHT(anotherstring,
length)

possibly?
 
Sub msg()

Dim strmsg As String
Dim i As Long

For i = 65 To 90
strmsg = strmsg & " " & Chr(i)
MsgBox strmsg
Next
End Sub

cheers
JulieD
 
Take a look at help for Mid().

Dim myStr As String
myStr = "abcdefghijklmnopqrstuvwxyz"
MsgBox myStr
Mid(myStr, 3, 6) = "123456"
MsgBox myStr

But I missed understood what you meant by build.

You might find String() and Space() useful, too.
 
Back
Top