Issues with running a Procedure in Excel 2003

**saurabhpunn** · 05-14-2012, 08:05 AM

Hi,

I'm new to VBA and following a book called Mastering Excel 2003 Programming with VBA to learn. I'm stuck on one of the examples given in the book. Please see the details below:

1: I've created an Excel sheet under C:\Examples\ named Example.xls. The sheet1 os the excel has data in Column B3 (="animal"), Column B4 (="art") and Column B5 (="test"). The pupose of the code (Below) is to make the column bold if the data starts with "a".

2: As given in the book, I've added a module to this sheet & copied the below code to the module:

Please Login or Register  to view this content.

3: However, when I try to execute the above mentioned code, the strange thing is that Nothing Happens. What I mean is that No Error is thrown & nor does the data in sheet1 is made bold.

Can someone pls help me understand what exactly is the issue here?

Note: Just to make sure if other piece of code is running through a module, I added the below code to module & it works (Gives me an Output):

Please Login or Register  to view this content.

**JBeaucaire** · 05-14-2012, 08:34 AM

In Excel the letters "a" and "A" are not automatically equivalent. You can tell Excel to treat upper and lower case as equivalent in the macros in that module by putting this at the top of that module:

Please Login or Register  to view this content.

Other ways is to fix the test so it matches the lower case values:

Please Login or Register  to view this content.

Or making the string upper case before you test "A":

Please Login or Register  to view this content.

**rvasquez** · 05-14-2012, 08:35 AM

Hello there,

Are the values in B3 and B4 capitalized? In other words in B3 is it "animal" or "Animal" and in B4 is it "art" or "Art"? In VBA things are case sensitive so if in your Example worksheet the values begin with a lowercase "a" then VBA does not recognize them as "A". Change the "A" in the code to "a" or capitalize the "a" in animal and art to make the code run correctly.

Let me know if this works!

Thanks!

**saurabhpunn** · 05-15-2012, 06:16 AM

Hi,

I did tried with both the options (Using the Font as "a" instead of "A" and by mentioning the Compare Text code.

However, still nothing is happening.

Is this because I'm trying to open a Sheet, which is already opened?

Thanks,