Can somebody confirm this?

[bralew]

Hi All,

I have some code which again activates alarms/warnings. It works fine although I don't think its good practice due to my misunderstanding of when to use ""

Please Login or Register  to view this content.

For example, should this line:

Please Login or Register  to view this content.

read as:

Please Login or Register  to view this content.

Any help would be much appreciated as I've potentially hundreds of these to do and do not want to start off on the wrong foot.

[pjwhitfield]

If its text then it should have speech marks so yes "GECKO" is the correct use

If a control, variable etc can contain anything other than numbers then generally it should be encased in speech marks ("" or ')

[xlnitwit]

You ought also to be aware by now that Val converts numeric text to a true number value. Therefore Val() will never equal "Gecko".

[bralew]

That's what I thought xlnitwit?

[xlnitwit]

They are two separate issues.
Unless GECKO is the name of a variable, it should always appear as "GECKO" in your code.
Val is useful for coercing a userform control that contains a numeric string into a true number value. If you type 123 into a control on a form, its Value or Text properties will return "123" as a String. Val will convert that into the actual number 123.

[bralew]

I've now removed Val. I was confused between the use of Value and Vale. Thanks all