UK Excel User Group Conference

[xld]

F7 was a very usefult tip for me in the VBE!

I know, I saw you look at me when I said it, it was almost respect

 

[cornflakegirl]

What does F7 do?

 

[xld]

What does F7 do?

It opens the code window of the object selected in the VBE explorer.

Especially useful on forms, as double-click there opens the object, and I HATE right-click>View Code.

 

[xld]

I appreciate that of all the subjects, VBA is the hardest to pitch at the right level. I just assumed that given the number of MVPs, the content would be quite advanced. Not a complaint, just an observation. I still managed to pick up a few tips (All these years I've been writing code and I didn't know about Ctrl+Space to display Intellisense!).

Ctrl-Space is not really display Intellisense, it is an auto-complete. So if you type in a unique string it will fully complete it. It will display a list of items if it is not (yet) unique aka Intellisense, but it is a little different.

I find especially useful with constants, as I always upper case my constants, but if you enter them in code and put one letter lower case, VBA will change them all, so your constant now has a lower-case letter in it. I just type the first part of my constant, any case, and then Ctrl-Space which completes it AND upper-cases it, hence not destroying my coding style.

 

[cornflakegirl]

Especially useful on forms, as double-click there opens the object, and I HATE right-click>View Code.

< lightbulb >Yeah, that's really annoying on forms.

 

[DonkeyOte]

I learnt some little tricks too but also learnt that I'm guilty of using things "as they come out of the box" and was ashamed to say that I was guilty of many of Simon's points about VBE don'ts...

Incidentally, congrats Emma...

 

[Russ At Index]

Happy Good Friday Chaps & Chappess !!!

Sorry for not responding earlier , i have been out of action
with the dreaded lurgy , of which , I know Mr Schollar can relate to !!

(Hi Rich , Bryony , Dom , Luke & Colin you Guys Ok ??)

Anyone had there " Thank You " from Microsoft yet ??????

My inbox appears MT from MS !!!

Finally , to Nick & all the presentation team ,many thanks , thoroughly
enjoyed the event !!!

Reagrds

Russ

 

[Richard Schollar]

Hi Russ

I hope it wasn't me you caught it off of!

Glad you are feeling better now

 

[Greg Truby]

I find especially useful with constants, as I always upper case my constants, but if you enter them in code and put one letter lower case, VBA will change them all, so your constant now has a lower-case letter in it. I just type the first part of my constant, any case, and then Ctrl-Space which completes it AND upper-cases it, hence not destroying my coding style.

That does not happen to me on your garden variety constants. They retain whatever case characteristics they have in the CONST statement. That only happens to me with enumerated constants - and yes - pi**** me off every time; so I always use intellisense/autocomplete on those.

Also, not sure what you consider to be intellisense versus autocompletion; i.e. I had used the terms interchangeably as do others. If you wouldn't mind, perhaps you could clarify?

 

[xld]

That does not happen to me on your garden variety constants. They retain whatever case characteristics they have in the CONST statement. That only happens to me with enumerated constants - and yes - pi**** me off every time; so I always use intellisense/autocomplete on those.

That is what I meant also, I use enumerated constants so often and get that problem so often I failed to differentiate. Ctl-Space stops the problem though.

Also, not sure what you consider to be intellisense versus autocompletion; i.e. I had used the terms interchangeably as do others. If you wouldn't mind, perhaps you could clarify?

If you believe everything/anything that you read in Wikipaedia ...

My understanding of intellisense is that it is an auto listing facility of library members, autocomplete is just that, completing a name from what is given so far, including providing a list if multiple matches.