Print cell contents in a message box

Mar 4th, 2002, 08:28 AM

Hi,

I want to print the contents of a cell in a messagebox. However, the horizontal position changes: so A1, A2, A3. I have a var which speficief the horizontal number (form a for next loop)

So, I have to paste some stuff together but I can`t seem tot get it to work.

MsgBox cellcontents A & (horzizontal value which I get from the for next loop) is missing , vbCritical, "Uncomplete"

anyone who can give me hand?
Appreciate it.

Remi
Holland.

Mar 4th, 2002, 11:22 AM

Hi Remi,

Firstly, since you mention "horizontal" component changes, I assume you really meant not A1,A2,A3, but rather A1,B1,C1? If this is the case then suppose you have named your "horizontal" (column) index iCol. Then

MsgBox Cells(1,iCol) & " is missing" , vbCritical, "Uncomplete"

If, on the other hand, you really meant to change the row rather than column (in which case your "horizontal" component is really "vertical", then

MsgBox Cells(iRow,1) & " is missing" , vbCritical, "Uncomplete"

Mar 5th, 2002, 03:08 AM

Yeah, sorry I was mistaking there.
Hey thnanks for the help!

Remi.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 08:28 AM	#1
Guest Posts: n/a	Hi, I want to print the contents of a cell in a messagebox. However, the horizontal position changes: so A1, A2, A3. I have a var which speficief the horizontal number (form a for next loop) So, I have to paste some stuff together but I can`t seem tot get it to work. MsgBox cellcontents A & (horzizontal value which I get from the for next loop) is missing , vbCritical, "Uncomplete" anyone who can give me hand? Appreciate it. Remi Holland.

Mar 4th, 2002, 11:22 AM	#2
Guest Posts: n/a	Hi Remi, Firstly, since you mention "horizontal" component changes, I assume you really meant not A1,A2,A3, but rather A1,B1,C1? If this is the case then suppose you have named your "horizontal" (column) index iCol. Then MsgBox Cells(1,iCol) & " is missing" , vbCritical, "Uncomplete" If, on the other hand, you really meant to change the row rather than column (in which case your "horizontal" component is really "vertical", then MsgBox Cells(iRow,1) & " is missing" , vbCritical, "Uncomplete"

Mar 5th, 2002, 03:08 AM	#3
Guest Posts: n/a	Yeah, sorry I was mistaking there. Hey thnanks for the help! Remi.