How can I use the .value code?

**cannon_lab** · 12-20-2007, 06:49 AM

Hi,
I got the following bit of code from this forum a few days ago:

Please Login or Register  to view this content.

It works beautifully. I was just wondering about the .value extension, as essentially I want to modify one of the following to check for the letter X, rather than a number

Please Login or Register  to view this content.

Can I use the .Value extension or do I need to use another tag? I tried using

Please Login or Register  to view this content.

but it doesn't seem to work. What can I do? Is the >=1 bit the problem? If so, can I limit this to >=1 and <=99, and how can I do this?

**davesexcel** · 12-20-2007, 07:15 AM

Originally Posted by cannon_lab

Hi,
I got the following bit of code from this forum a few days ago:

Please Login or Register  to view this content.

It works beautifully. I was just wondering about the .value extension, as essentially I want to modify one of the following to check for the letter X, rather than a number

Please Login or Register  to view this content.

Can I use the .Value extension or do I need to use another tag? I tried using

Please Login or Register  to view this content.

but it doesn't seem to work. What can I do? Is the >=1 bit the problem? If so, can I limit this to >=1 and <=99, and how can I do this?

Please Login or Register  to view this content.

should work

**cannon_lab** · 12-20-2007, 08:18 AM

What does .value mean specifically?

**davesexcel** · 12-20-2007, 08:24 AM

Originally Posted by cannon_lab

What does .value mean specifically?

? value
specifically?
http://en.wikipedia.org/wiki/Value

**cannon_lab** · 12-20-2007, 08:56 AM

Yeah that's really not helpful, if I wanted an answer from Wikipedia I would have gone on there.

I mean what does it represent? - numbers, strings, letters
How can it be used?

I am new to VBA and most of the internet resources I have found on the subject are useless- they tell you how to achieve results, but not why it works.

**AndySuk** · 12-20-2007, 09:25 AM

Hi

Yeah - it's a bit of a minefield!...but good fun (honest!).

.value is a property of a an object. Not all objects have the value property and the value is not always the same data type.

In your example .value is the property of a range object so in its simplest form...

fred=range("H8").value
...so fred is a carrier for whatever value is in cell "H8". fred can be anything you can like - it's a bag so that you can report on whatever is in cell "H8" so, later on, if you wanted to report on fred you could write

msgbox (fred) which is the same as writing msgbox (range("H8").value)

As a suggestion try and record some simple excercises in Excel using the Tools>Macro>Record tool. Then go and look at what you've recorded in the Visual Basic editor. The simpler you make them the easier it will be to understand the example.

Hope that's of some help.

**cannon_lab** · 12-20-2007, 10:39 AM

Cheers, that is really useful.

How can I use the .value code?

LinkBack

Thread Tools

Rate This Thread

Display

How can I use the .value code?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions