Excel object properties

RedXIV

Hi Guys,

Just starting doing my very first piece of Excel coding with VBA and I've a quick question that will hopefully get me going faster. When I have a variable belonging to an object i.e:

dim i as interger

i.value = 4

Very simple example above, I want to know if there is someway I can get the definition of ".value" in Excel somewhere to tell me what it does. I'm working on a program that someone else has written and am hoping there is a tool in excel as opposed to having to google something every two mins.

Hope that makes sense,

Thanks!

TrueDub

The help within VBA isn't the easiest to use but it has all the info you need within it.

Using google to research things is a part of programming - your use gets more refined as your experience rises, but you never stop doing it.

henryporter

There's a few sites that give great help on Excel and VBA namely; http://www.functionx.com/vbaexcel/, http://www.mrexcel.com/, http://www.contextures.com/index.html and http://www.ozgrid.com/ (the last one and Mrexcel both excellent).

namelessguy

RedXIV wrote: »

Hi Guys,

Just starting doing my very first piece of Excel coding with VBA and I've a quick question that will hopefully get me going faster. When I have a variable belonging to an object i.e:

dim i as interger

i.value = 4

Very simple example above, I want to know if there is someway I can get the definition of ".value" in Excel somewhere to tell me what it does. I'm working on a program that someone else has written and am hoping there is a tool in excel as opposed to having to google something every two mins.

Hope that makes sense,

Thanks!

I'm in a similar position as yourself. I've been asked to finish some changes to an access database started by a colleague who's left and created by another colleague who's also left.

Unfortunately Google is going to be your number one reference material, at least I've found that to be the case. Sample code, solutions to common problems, explanations of the various methods and objects. As you google them you'll notice a trend in the quality of answers from certain sites as the previous posters have indicated and you'll use them more often.

Evil Phil

Probably not a help but when your in the VBA editor place the cursor on the code you want help with and hit the F1 key. Should bring up office help, works in Excel 2010 + Internet connection.