Site Issues - VBA Code Formatting / Person to Person Messaging

[Coding4Fun]

1. When replying to a thread, inserting VBA code using a variable QtyRem causes the format to not display properly.

For example

QtyRem = Qty - 2500
If QtyRem > 1200 Then

2. (Person to Person) Messaging does not seem to have the same functionality as the thread posting, meaning I cant insert an image easily here like I can in the thread posts, I only get the option for "URL" in personal messages but in the threads I can choose to upload a picture from my PC.

 

[smozgur]

1- Rem is a reserved keyword in VB/A (comment block), that's why this code doesn't display properly. On the other side, it is obviously a bug in the code highlighter as it doesn't recognize that the Rem should be a whole keyword to trigger the code highlighting. I will report this issue to the third party code highlighter that the forum software is using their scripts. Thanks for reporting this.

2- That's correct. Uploading images is not allowed in the conversation messages in the MrExcel Message Board.

 

[Coding4Fun]

1- Rem is a reserved keyword in VB/A (comment block), that's why this code doesn't display properly. On the other side, it is obviously a bug in the code highlighter as it doesn't recognize that the Rem should be a whole keyword to trigger the code highlighting. I will report this issue to the third party code highlighter that the forum software is using their scripts. Thanks for reporting this.

2- That's correct. Uploading images is not allowed in the conversation messages in the MrExcel Message Board.

1 - Yes I understand Rem is a keyword but it is a bug in the text highlighter as mentioned - Thank you
2 - I believe you are incorrect in your statement. See screenshots provided

 

[RoryA]

I believe you are incorrect in your statement

He did say uploading images is not allowed...

 

[smozgur]

I am not sure if/when they will fix it, so I just went ahead and fixed the associated script on our installation. It should be working correctly now.

abc = "variable"
QtyRem = "this is another variable"
QtyRem2 = "this is another variable" 'and comment
Rem This is a comment
' This is also a comment

 

[Coding4Fun]

Awesome thanks for fixing the VBA code formatting issue.

In regards to the images I guess maybe I am missing the play on words or something.

When I go into personal messaging there is a button to insert an image, if adding images to personal messages is not allowed then shouldn't the option be removed?

Or is it by using the URL you are not actually "uploading" the picture?

 

[smozgur]

Awesome thanks for fixing the VBA code formatting issue.

You're welcome.
Honestly, I even forgot the Rem keyword as a BASIC coder. Apparently, the associated regex pattern was not designed well, so it was failing to catch the right Rem keyword. Thanks for reporting the problem.

by using the URL you are not actually "uploading" the picture?

That's correct.
Inserting an image by a URL: The image file is stored somewhere else on the web, so it is displayed from there.
Inserting an image by uploading the image file: The image file is stored in the MrExcel server.

 

[Coding4Fun]

Thank you for your assistance and clarification.