excel course in london - User defined range in Excel

The UK's most regular instructor-led training courses.
Training information: excel course in london · Microsoft excel training · VBA courses London

Resolved · Low Priority · Version Standard

User defined range in Excel

Ian has attended:
Excel VBA course

by - delegate Ian [3 posts] (2007 Aug 21 Tue, 12:13) Reply

Please confirm the coding required so that a formatting procedure I have written is only applied to the range selected by the user i.e. the user will select the range then run my VBA procedure via a button on their toolbar.

Thanks
Ian

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: User defined range in Excel

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 10:59) Reply

Hi Ian. As long as you are using the ".Selection" identifier within your code, your procedures should only run on the range selected by the user.

Hope this helps,

Anthony

RE: User defined range in Excel

by - delegate Ian [3 posts] (2007 Sep 25 Tue, 15:49) Reply

Hi Anthony

Thanks for your reply

Please could you give me an example of the code when the ".selection" identifier is used.

Thanks
Ian

RE: User defined range in Excel

by - trainer Rich platinum contributer [713 posts] (2007 Oct 24 Wed, 13:53) Edited on 2007 Oct 24 Wed, 13:53 Reply

Ian,

Sorry for the delay in replying - Anthony is on sabbatical.

Try: this page

Regards, Rich

· MS Excel: Excel At Making The Most Of Your Christmas
· Customized Financial Excel Courses in London
· Benefits of learning about Excel charts
· Microsoft Excel Training: Essential for Today's Employees
· How Excel Training Can Improve Your Company's Sales Process

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips