Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why does this fail?
public sub test()
dim c as integer,s1 as string, s2 as string s1="My Message" s2 = "My Title" c=msgbox(s1,vbyesno,s2) if c=vbyes then msgbox "hi" else msgbox "bye" end if end sub this is always displaying "bye" why? c (just after assignment) contains 6 at the test, c is empty what am i missing? it works using if msgbox(s1,vbyesno,s2)=vbyes then .... jooc thanks J |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
why does this fail?
Don't know why it does not owrk for you. It works for me... The only thing I
see is that msgbox returns a long not an integer. Not thgat it has ever caused me a problem using int but as a technicallity... Jim Thomlinson "Gixxer_J_97" wrote: public sub test() dim c as integer,s1 as string, s2 as string s1="My Message" s2 = "My Title" c=msgbox(s1,vbyesno,s2) if c=vbyes then msgbox "hi" else msgbox "bye" end if end sub this is always displaying "bye" why? c (just after assignment) contains 6 at the test, c is empty what am i missing? it works using if msgbox(s1,vbyesno,s2)=vbyes then .... jooc thanks J |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
why does this fail?
It works fine for me too. As Jim says, technically the button constants are
Longs, but I also don't get a problem with Integer, and I tried with 97, 2000 and XP. If you have 2003, try it with Long. -- HTH RP (remove nothere from the email address if mailing direct) "Jim Thomlinson" wrote in message ... Don't know why it does not owrk for you. It works for me... The only thing I see is that msgbox returns a long not an integer. Not thgat it has ever caused me a problem using int but as a technicallity... Jim Thomlinson "Gixxer_J_97" wrote: public sub test() dim c as integer,s1 as string, s2 as string s1="My Message" s2 = "My Title" c=msgbox(s1,vbyesno,s2) if c=vbyes then msgbox "hi" else msgbox "bye" end if end sub this is always displaying "bye" why? c (just after assignment) contains 6 at the test, c is empty what am i missing? it works using if msgbox(s1,vbyesno,s2)=vbyes then .... jooc thanks J |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
why does this fail?
I tried in in 2003 and 2000. It wall workd fine for me... I would love to
know what might be causing that. Jim Thomlinson P.S. Bob is the one who let me in on the whole long thing. I used to always use int also. Until Bob pointed out the only two (very obscure) long return values that a message box can send. That knowledge will stick with me until long after I am dead... Thanks Bob... "Bob Phillips" wrote: It works fine for me too. As Jim says, technically the button constants are Longs, but I also don't get a problem with Integer, and I tried with 97, 2000 and XP. If you have 2003, try it with Long. -- HTH RP (remove nothere from the email address if mailing direct) "Jim Thomlinson" wrote in message ... Don't know why it does not owrk for you. It works for me... The only thing I see is that msgbox returns a long not an integer. Not thgat it has ever caused me a problem using int but as a technicallity... Jim Thomlinson "Gixxer_J_97" wrote: public sub test() dim c as integer,s1 as string, s2 as string s1="My Message" s2 = "My Title" c=msgbox(s1,vbyesno,s2) if c=vbyes then msgbox "hi" else msgbox "bye" end if end sub this is always displaying "bye" why? c (just after assignment) contains 6 at the test, c is empty what am i missing? it works using if msgbox(s1,vbyesno,s2)=vbyes then .... jooc thanks J |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
why does this fail?
hmmm - i'm using 2003 and on 2 different machines it did the same thing
both xp pro sp2 - dunno if that makes a difference also in my project and in a new workbook it failed too - i'm stumped. it has worked in the past, which is why i'm confused as to why it doesn't now. /shrug and i used int because msgbox returns an integer - according to the help. but thanks for pointing that out. J "Jim Thomlinson" wrote: I tried in in 2003 and 2000. It wall workd fine for me... I would love to know what might be causing that. Jim Thomlinson P.S. Bob is the one who let me in on the whole long thing. I used to always use int also. Until Bob pointed out the only two (very obscure) long return values that a message box can send. That knowledge will stick with me until long after I am dead... Thanks Bob... "Bob Phillips" wrote: It works fine for me too. As Jim says, technically the button constants are Longs, but I also don't get a problem with Integer, and I tried with 97, 2000 and XP. If you have 2003, try it with Long. -- HTH RP (remove nothere from the email address if mailing direct) "Jim Thomlinson" wrote in message ... Don't know why it does not owrk for you. It works for me... The only thing I see is that msgbox returns a long not an integer. Not thgat it has ever caused me a problem using int but as a technicallity... Jim Thomlinson "Gixxer_J_97" wrote: public sub test() dim c as integer,s1 as string, s2 as string s1="My Message" s2 = "My Title" c=msgbox(s1,vbyesno,s2) if c=vbyes then msgbox "hi" else msgbox "bye" end if end sub this is always displaying "bye" why? c (just after assignment) contains 6 at the test, c is empty what am i missing? it works using if msgbox(s1,vbyesno,s2)=vbyes then .... jooc thanks J |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
why does this fail?
Guess they need to update the documentation:
? typename(msgbox("ABCD")) Long -- Regards, Tom Ogilvy "Gixxer_J_97" wrote in message ... hmmm - i'm using 2003 and on 2 different machines it did the same thing both xp pro sp2 - dunno if that makes a difference also in my project and in a new workbook it failed too - i'm stumped. it has worked in the past, which is why i'm confused as to why it doesn't now. /shrug and i used int because msgbox returns an integer - according to the help. but thanks for pointing that out. J "Jim Thomlinson" wrote: I tried in in 2003 and 2000. It wall workd fine for me... I would love to know what might be causing that. Jim Thomlinson P.S. Bob is the one who let me in on the whole long thing. I used to always use int also. Until Bob pointed out the only two (very obscure) long return values that a message box can send. That knowledge will stick with me until long after I am dead... Thanks Bob... "Bob Phillips" wrote: It works fine for me too. As Jim says, technically the button constants are Longs, but I also don't get a problem with Integer, and I tried with 97, 2000 and XP. If you have 2003, try it with Long. -- HTH RP (remove nothere from the email address if mailing direct) "Jim Thomlinson" wrote in message ... Don't know why it does not owrk for you. It works for me... The only thing I see is that msgbox returns a long not an integer. Not thgat it has ever caused me a problem using int but as a technicallity... Jim Thomlinson "Gixxer_J_97" wrote: public sub test() dim c as integer,s1 as string, s2 as string s1="My Message" s2 = "My Title" c=msgbox(s1,vbyesno,s2) if c=vbyes then msgbox "hi" else msgbox "bye" end if end sub this is always displaying "bye" why? c (just after assignment) contains 6 at the test, c is empty what am i missing? it works using if msgbox(s1,vbyesno,s2)=vbyes then .... jooc thanks J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does hyperlink fail? | Excel Discussion (Misc queries) | |||
Templates fail to open | Setting up and Configuration of Excel | |||
Templates Fail | Excel Discussion (Misc queries) | |||
hyperlinks fail after saving | Excel Discussion (Misc queries) | |||
pass fail | New Users to Excel |