Worksheet_Change not recognizing certain values

[hk57]

I am trying to use the worksheet function to unhide certain rows... just for whatever... whatever...

Anyways, problem is certain characters do not exist to be recognized in vba code. ₂ apparently doesn't work... which is annoying that subscripting a 2 doesn't carry through references. I am also needing to look at greek scripting, such as mu (μ).

Another part that really bugs me, I am not sure what is having a hiccup out of these options:

Please Login or Register  to view this content.

The first, second, fourth, and fifth all work... when those values are input into the targeted cell then it correctly unhides the values on sheet 45. But the third case doesn't ever work. I don't get why. If it doesn't like the "Fd" then why does it work on the second case... and it isn't like it is having an issue with the "lb/hr" because the fifth case works.

In attached workbook, the worksheet change references to the second tab "RATA", Sheet46, cell B1... and will be through B13 once I get B1 working. The error does not only occur with the above Cases, a similar type of casing applies under other gas types and it is always the lb/hr-Fd that doesn't work. Far as I can tell, everything else doesish (again, minus the mu until I figure my alternative...).


Thanks for any help!

[vba_php]

I ran the code by selecting a val from the validation dropdown and none of the 5 executionary lines you references worked. the value I chose was: Nitrogen Oxides, Emissions, lb/hr-Fd. and I had rows 70 - 77 hidden. and when the code ran that included the 5 lines you posted:

Please Login or Register  to view this content.

none of the lines 70 - 77 were unhidden.

I even tried this:

Please Login or Register  to view this content.

and the row didn't become unhidden.

[pjwhitfield]

I ran the code by selecting a val from the validation dropdown and none of the 5 executionary lines you references worked. the value I chose was: Nitrogen Oxides, Emissions, lb/hr-Fd. and I had rows 70 - 77 hidden. and when the code ran that included the 5 lines you posted:

Please Login or Register  to view this content.

none of the lines 70 - 77 were unhidden.

I even tried this:

Please Login or Register  to view this content.

and the row didn't become unhidden.

There is a space at the end of that entry (and probably on others as well) which is stopping it from matching.

If you change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

All should work

[vba_php]

There is a space at the end of that entry (and probably on others as well) which is stopping it from matching.

If you change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

All should work

hmmmmm....interesting. thanks! obviously I did not check that, nor did I intend to. but I'm sure he/she will make good use of that advice of yours.

[mjr veverka]

... certain characters do not exist to be recognized in vba code ...
... I am also needing to look at greek scripting, such as mu (μ) ...

You must use unicode => for greek characters, it seems to me that these are codes from 911 to 974.

Please Login or Register  to view this content.

Your code could be standardized, because the identified phrases for the "B2" to "B13" sections are identical in your code.
The differences are between searched phrases for "B1" in relation to the "B2", "B3", ...., "B13" sections:
(the differences - mainly - are overabundance of spaces and additionally "minus"/dash signs)

B1 ==> B2:B13
-------------------------------------------------------------------------
Velocity, ft/sc ==> Velocity , ft/sc
Velocity, ft/min ==> Velocity , ft/min
Velocity, m/sec ==> Velocity , m/sec

Sulfur Dioxide, Conc., ppmdv @%O2 ==> Sulfur Dioxide, Conc. at 4% Oxygen, ppmw @4% O?
Sulfur Dioxide, Emissions, lb/mmBTU-Fd ==> Sulfur Dioxide, Emissions, lb/mmBTU Fd
Sulfur Dioxide, Emissions, lb/hr-Fd ==> Sulfur Dioxide, Emissions, lb/hr Fd
Sulfur Dioxide, Emissions, lb/mmBTU-Fc ==> Sulfur Dioxide, Emissions, lb/mmBTU Fc
Sulfur Dioxide, Emissions, lb/hr-Fc ==> Sulfur Dioxide, Emissions, lb/hr Fc

Nitrogen Oxides, Conc., ppmdv @%O2 ==> Nitrogen Oxides, Conc. at 4% Oxygen, ppmw @4% O?
Nitrogen Oxides, Emissions, lb/mmBTU-Fd ==> Nitrogen Oxides, Emissions, lb/mmBTU Fd
Nitrogen Oxides, Emissions, lb/hr-Fd ==> Nitrogen Oxides, Emissions, lb/hr Fd
Nitrogen Oxides, Emissions, lb/mmBTU-Fc ==> Nitrogen Oxides, Emissions, lb/mmBTU Fc
Nitrogen Oxides, Emissions, lb/hr-Fc ==> Nitrogen Oxides, Emissions, lb/hr Fc

Carbon Monoxide, Conc., ppmdv @%O2 ==> Carbon Monoxide, Conc. at 4% Oxygen, ppmw @4% O?
Carbon Monoxide, Emissions, lb/mmBTU-Fd ==> Carbon Monoxide, Emissions, lb/mmBTU Fd
Carbon Monoxide, Emissions, lb/hr-Fd ==> Carbon Monoxide, Emissions, lb/hr Fd
Carbon Monoxide, Emissions, lb/mmBTU-Fc ==> Carbon Monoxide, Emissions, lb/mmBTU Fc
Carbon Monoxide, Emissions, lb/hr-Fc ==> Carbon Monoxide, Emissions, lb/hr Fc

Total Hydrocarbons, Conc., ppmwv @%O2 ==> THC at 3% Oxygen wet, ppmw @3% O?
Total Hydrocarbons, Conc., ppmdv @%O2 ==> THC at 3% Oxygen dry, ppmd @3% O?
Total Hydrocarbons, Emissions, lb/mmBTU-Fd ==> Total Hydrocarbons, Emissions, lb/mmBTU Fd
Total Hydrocarbons, Emissions, lb/hr-Fd ==> Total Hydrocarbons, Emissions, lb/hr Fd
Total Hydrocarbons, Emissions, lb/mmBTU-Fc ==> Total Hydrocarbons, Emissions, lb/mmBTU Fc
Total Hydrocarbons, Emissions, lb/hr-Fc ==> Total Hydrocarbons, Emissions, lb/hr Fc


You should make yourself an additional sheet that will be a dictionary of searched phrases.
On its basis, the code will identify the given phrase depending on the cell.
Otherwise, if the number of searched phrases increases, your code will be like "The South Dakota Chainsaw Massacre" ...

Sample schema:

Sheet "RATA" module:

Please Login or Register  to view this content.

Standard module:

Please Login or Register  to view this content.