Messge in a Message box not working as I would like

[k.tanton]

Good Afternoon..... Can someone please tell me what I need to do to this line of code for a message box to make it work please.

Please Login or Register  to view this content.

I can get "Record " & ThisWorkbook.Worksheets("Moorhouse").Range("RentAnchor").Offset(TargetRow, 1).Value, this bit works but not the last bit of annotation...grrrrr

Any help would be much appreciated. Please be gentle as I am still learning....

Thank you in advance.

[6StringJazzer]

You can't build a string with commas. No idea what you are trying to do with the 0.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time to keep the thread moving because it was only one line. --6StringJazzer

[ByteMarks]

No idea what you are trying to do with the 0.

0 is the vbExclamation icon

[kaasplankje]

Then write vbExclamation

[6StringJazzer]

When you show code that doesn't work, it is best to describe what result you want. I had to guess.

If Message is your title then use this. I am not a fan of using the numbers instead of the built-in constants:

Please Login or Register  to view this content.

0 is the vbExclamation icon

Not correct. 0 is the default, and means "OK button only." To get the exclamation icon use vbExclamation, which has a value of 48.

[ByteMarks]

Not correct. 0 is the default, and means "OK button only.

Sorry, you're quite right.