« Maintaining Code
Temperature Number Formats »

Working with Tables in Excel 2007 (VBA)

1st May 2007, 11:55 am by jkpieterse

In a previous post about Excel 2007’s new table functionality I promised to write something about working with them using VBA.

I finally got ’round to doing that, so here is my first go at it:

Working with Tables in Excel 2007 (VBA)

Have a look and write a couple of comments if you like!

Regards,

Jan Karel Pieterse
www.jkp-ads.com

Category: MVP, VBA, Excel12  |  Comment (RSS)  |  Trackback

2 Comments

  1. Amber:

    Hello,
    I’m a networking major and I am looking for VBAs to make a switchborad in Excel. I searched everywhere and I couldn’t find anything. Do you know of a Website where I can get help creating a swithboard in Excel? I would really appreciate it; I am taking the final project and part of the capstone is to create financials statements and put them in the swithboard interface of Excel. I have already created the record macros and the interface itself, however, there is too much I don’t know how to do. Thank you in advance for any help you might give ,if not, if not thank you for you time. Sincerely and respectfuly Amber.

    4 May 2007, 2:46 am

  2. Jon Peltier:

    Amber -

    Do you mean dashboard? This e-book is a very nice treatment of dashboards in Excel:

    http://www.1shoppingcart.com/app/?af=371285

    There is more information on author Charley Kyd’s web site, http://exceluser.com/.

    4 May 2007, 12:42 pm

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment