Module reveals 4 red lines of red code; what is wrong here?

**chin67326** · 01-15-2016, 08:57 AM

https://excelmate.wordpress.com/2012...-boxes-part-3/

The above article/site is very informative but when I mimic the example 100%, 4 lines of red are produced in the code, stating that something is not right.

Essentially the aim is to use the below code:

Please Login or Register  to view this content.

Which will produce the below message boxes when the various buttons are clicked:

13a.jpg

However, when the code is entered in a module, 4 lines are red as shown below:

13b.JPG

What do you think is wrong here?

**StephenR** · 01-15-2016, 09:16 AM

When I replace the slanting double quotes with normal double quotes it works.

**chin67326** · 01-15-2016, 01:21 PM

Originally Posted by StephenR

When I replace the slanting double quotes with normal double quotes it works.

Good catch, thanks StephenR!

I had to tweak further before it could work for me too, for example there was an unecessary underscore in the code. For anyone interested in the final working version of the code, see the below.

Please Login or Register  to view this content.

Module reveals 4 red lines of red code; what is wrong here?

LinkBack

Thread Tools

Rate This Thread

Display

Module reveals 4 red lines of red code; what is wrong here?

Re: Module reveals 4 red lines of red code; what is wrong here?

Re: Module reveals 4 red lines of red code; what is wrong here?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Code locks cells when inserted in sheet module but returns error in standard module

A function that reveals the formula of another cell

Macro Module Won't Run All Lines in Excel 2007

how to access Sheet module, normal module, Worbook module to type code

[SOLVED] code in module A to not execute a Worksheet_SelectionChange sub of another module

.OnAction points to wrong file.module.procedure

Run worksheet module code from workbook module?

In Excel vba how do you Launch code a standalone Module from a Form or other Module ?

Bookmarks

Bookmarks

Posting Permissions