VBA

Resolved · Low Priority · Version 2003

Thu 30 Oct 2008, 15:58 Delegate Philipp said...

Philipp has attended:
Excel VBA Intro Intermediate course

VBA

How can I replicate the group by function in SQL in VBA?

Thu 27 Nov 2008, 12:37 Trainer Jacob said...

RE: VBA

Hi Philip

Thanks for your post.

We can recommend a couple of approaches to your requirement.

1) You to attend our Excel VBA Advanced course so that you can "grow" your own knowledge and thereby bulid your solution.

links to course info:

https://www.stl-training.co.uk/vba-training.php

2) We take the consultative approach where you send us a sample file of what you are working on togther with a brief of key objectives.

We review this and let you know if we can assist, the scope of work and related costs.

If you would like to look at the consultative appraoch please let us know.

Regards

Jacob

Thu 4 Dec 2008: Automatically marked as resolved.

Excel tip:

Validating text entries

1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula:

=IsText (A1)

where A1 is the first cell in the range.
6. Click OK.

View all Excel hints and tips

VBA

VBA

RE: VBA

Excel articles

Excel tip:

Validating text entries