Re: Help with script: STARTING A NEW SUB.. (within sub?)
- From: Nastech <Nastech@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Nov 2008 07:03:00 -0800
hi, sorry am at least little bit novice, guesse I insert my macro(?)
inbetween this somewhere? (dim means dimension? do I have to define that,
or is that for my button specified cell.. = "X" ?) thanks.
"Bob Phillips" wrote:
"FSt1" <FSt1@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message.
news:C2F82D89-0918-4C48-BB74-83F990401F15@xxxxxxxxxxxxxxxx
hi
you can't put a sub within a sub as least not like you are trying to do.
You can sort of.
Sub Caller()
Dim x
x = Int(Rnd() * 100) + 1
If x > 50 Then GoSub SubInASub
x = 3
Exit Sub
SubInASub:
MsgBox "SubInASub called"
End Sub
Not sure if this addresses the OP's problem; not saying you should do it;
not saying you shouldn't do it; just saying that you can.
- Follow-Ups:
- Re: Help with script: STARTING A NEW SUB.. (within sub?)
- From: Nastech
- Re: Help with script: STARTING A NEW SUB.. (within sub?)
- References:
- Re: Help with script: STARTING A NEW SUB.. (within sub?)
- From: Bob Phillips
- Re: Help with script: STARTING A NEW SUB.. (within sub?)
- Prev by Date: Converting time-formatted to text-based data
- Next by Date: Re: Excel 2002: Can I condition format block of cells ?
- Previous by thread: Re: Help with script: STARTING A NEW SUB.. (within sub?)
- Next by thread: Re: Help with script: STARTING A NEW SUB.. (within sub?)
- Index(es):