VBA msgbox syntax & breaks between boxes

[mewingkitty]

Heya y'all.

2 questions about msgbox's.

1 - While returning a msgbox, I seem to be unable to find the proper fashion of returning text, an integer or variable, and then more text. I can set the integer first with
msgbox(x) & "text"
Can't seem to get text, integer, then text.

2 - While returning multiple msgbox's, is it possible to make changes on the worksheet after each box? I realize this is in the middle of code which is running, so not sure if that's conceivable or not.

Thanks again guys & gals.

mew!

[Kenneth Hobson]

You are returning all string. Type conversion is being done for you.

Please Login or Register  to view this content.

returns "test1test"

2=Yes.

[mewingkitty]

You are returning all string. Type conversion is being done for you.

Code:
debug.print "test" & msgbox("test") & "test"
returns "test1test"

In my messagebox? No it doesn't...It just returns "test" once in the msgbox.

And I see I've done the classic move of asking if something is possible. Having been informed that it indeed can be done, how would one go about achieving a solution to my 2nd question?

[VBA Noob]

The debug display the string in the immediate window which is under the view menu

I suspect you should be using a userform by the sound of things but see if this link helps

http://spreadsheetpage.com/index.php...elected_range/

VBA Noob

[shg]

Mew, I'm totally confused. Maybe this?

Please Login or Register  to view this content.

[mewingkitty]

lol
That's amazingly cute, SHG.
I just need to become more familiar with code as I use it. I was under the impression that I needed a ( immedietly after the MSGBOX command, hence my issues with text after that.

Learned a helluva lot from this site with everyones help, and still learning more.

Always appreciated!

I'm going through the link you sent, VBA Noob, I think I can work with this.

and

mew!

[shg]

Mew, see also http://www.excelforum.com/excel-prog...-mismatch.html

And mark us up as solved ...