Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Visual basic

Visual basic

ResolvedVersion 2007

Tue 31 Mar 2009, 16:42 Delegate Stephen said...

Stephen has attended:
Excel VBA Intro Intermediate course

Visual basic

Can you recommend a reference text for VBA?

Tue 7 Apr 2009, 19:06 Trainer David said...

RE: visual basic

Hi Stephen

Welcome to the forum and 12 months support, we dont generally recommend particular books, however if you look at the PC magazines they will often do so, alternatively there are several newsgroups that you may want to peruse to read what people may be using.

Hope this answers your question

regards

Best Team

Tue 14 Apr 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

Visual basic

Visual basic

RE: visual basic

Excel articles

Excel tip:

Hide data in Excel Worksheets