Have following and can not seem to get it to work. tried ifs etc same as
others noluck. Want to show cell amount then have a vbyesno for user to
answer. If cel text length to long yes do this no exit. Heres what Ive tried
theamount msgbox is the hang up
Any one Thanks

Worksheets("desc").Select
Range("A2").Select
cellLength = Len(ActiveCell)
msgbox (cellLength)
theamount = msgbox("cellLength", prompt:="Is the Number over 232", _
Buttons:=vbYesNo)

hi,
inclose the msgbox in an if statement.
if msgbox(celllength & vbNewLine & "Is the Number over 232", _
vbYesNo) = vbYes Then
do something
Else
Exit Sub
end if

regards
FSt1
"Curt" wrote:

Have following and can not seem to get it to work. tried ifs etc same as
others noluck. Want to show cell amount then have a vbyesno for user to
answer. If cel text length to long yes do this no exit. Heres what Ive tried
theamount msgbox is the hang up
Any one Thanks

Worksheets("desc").Select
Range("A2").Select
cellLength = Len(ActiveCell)
msgbox (cellLength)
theamount = msgbox("cellLength", prompt:="Is the Number over 232", _
Buttons:=vbYesNo)

download mztools. one of the options is the msgbox assistant. it should help you
out.

http://www.mztools.com/v3/mztools3.htm

--


Gary


"Curt" wrote in message
...
Have following and can not seem to get it to work. tried ifs etc same as
others noluck. Want to show cell amount then have a vbyesno for user to
answer. If cel text length to long yes do this no exit. Heres what Ive tried
theamount msgbox is the hang up
Any one Thanks

Worksheets("desc").Select
Range("A2").Select
cellLength = Len(ActiveCell)
msgbox (cellLength)
theamount = msgbox("cellLength", prompt:="Is the Number over 232", _
Buttons:=vbYesNo)

Thanks for pulling my brain dead head out. This is first time I've used cell
length never seen the & vbnewline befor
Thanks much Mate

"FSt1" wrote:

hi,
inclose the msgbox in an if statement.
if msgbox(celllength & vbNewLine & "Is the Number over 232", _
vbYesNo) = vbYes Then
do something
Else
Exit Sub
end if

regards
FSt1
"Curt" wrote:

Have following and can not seem to get it to work. tried ifs etc same as
others noluck. Want to show cell amount then have a vbyesno for user to
answer. If cel text length to long yes do this no exit. Heres what Ive tried
theamount msgbox is the hang up
Any one Thanks

Worksheets("desc").Select
Range("A2").Select
cellLength = Len(ActiveCell)
msgbox (cellLength)
theamount = msgbox("cellLength", prompt:="Is the Number over 232", _
Buttons:=vbYesNo)

Thank You did download will see what I can do
Thanks Again

"Gary Keramidas" wrote:

download mztools. one of the options is the msgbox assistant. it should help you
out.

http://www.mztools.com/v3/mztools3.htm

--


Gary


"Curt" wrote in message
...
Have following and can not seem to get it to work. tried ifs etc same as
others noluck. Want to show cell amount then have a vbyesno for user to
answer. If cel text length to long yes do this no exit. Heres what Ive tried
theamount msgbox is the hang up
Any one Thanks

Worksheets("desc").Select
Range("A2").Select
cellLength = Len(ActiveCell)
msgbox (cellLength)
theamount = msgbox("cellLength", prompt:="Is the Number over 232", _
Buttons:=vbYesNo)