Page 1 of 6 123 ... LastLast
Threads 1 to 20 of 117

Forum: Excel and VBA Tips and Tricks

Tips on Formula and VBA

  1. Sticky Thread Sticky: Excel Macro Functions (GET.CELL)

    Started by Admin, 05-17-2011 08:56 AM
    excel 4.0 macro xlm, excel 4.0 xlm function, get.cell
    • Replies: 1
    • Views: 17,310
    Admin
    05-17-2011, 08:56 AM Go to last post

  2. Sticky Thread Sticky: Excel Macro Functions (GET.DOCUMENT)

    Started by Admin, 05-17-2011 09:03 AM
    get.document
    • Replies: 2
    • Views: 20,748
    Excel Fox
    06-29-2011, 08:10 PM Go to last post

  1. "What’s in a String"- VBA break down Loop through character contents of a string

    Started by DocAElstein, 02-07-2019 11:01 PM
    3 Pages •
    1 2 3
    9 Attachment(s)
    • Replies: 26
    • Views: 168,421
    DocAElstein
    07-09-2023, 04:57 PM Go to last post

  2. A Blinking Christmas Tree

    Started by Rick Rothstein, 12-03-2015 03:37 AM
    • Replies: 0
    • Views: 2,821
    Rick Rothstein
    12-03-2015, 03:37 AM Go to last post

  3. Add Control to List On Right-Click

    Started by Rasm, 04-17-2011 08:16 PM
    • Replies: 0
    • Views: 2,394
    Rasm
    04-17-2011, 08:16 PM Go to last post

  4. Add Shape With Hyperlink To Another Sheet

    Started by Excel Fox, 07-30-2011 04:51 AM
    add shape hyperlink
    • Replies: 0
    • Views: 3,856
    Excel Fox
    07-30-2011, 04:51 AM Go to last post

  5. Average Of The X Largest Numbers

    Started by Excel Fox, 04-16-2011 04:15 PM
    average largest number 1 Attachment(s)
    • Replies: 0
    • Views: 1,527
    Excel Fox
    04-16-2011, 04:15 PM Go to last post

  6. Backup all modules, class modules and userforms to a selectable folder

    Started by MrBlackd, 04-06-2014 02:25 AM
    • Replies: 1
    • Views: 1,956
    Admin
    04-06-2014, 08:33 AM Go to last post

  7. BBCode Table

    Started by pike, 01-19-2016 02:19 PM
    7 Pages •
    1 2 3 ... 7
    • Replies: 61
    • Views: 165,366
    DocAElstein
    05-16-2016, 02:04 PM Go to last post

  8. Lightbulb Change Case of Text in Excel

    Started by Admin, 08-11-2011 08:33 AM
    change case, lower, proper, sentence case, upper
    • Replies: 0
    • Views: 2,187
    Admin
    08-11-2011, 08:33 AM Go to last post

  9. Change Pivot Table Data Source Using A Drop Down List

    Started by hanishgautam, 07-05-2013 09:33 AM
    • Replies: 0
    • Views: 2,957
    hanishgautam
    07-05-2013, 09:33 AM Go to last post

  10. Poll Poll: Changing Hyperlink To Another Sheet By Changing Value Of Cell

    Started by Excel Fox, 04-30-2011 11:55 PM
    hyperlink by cell value 1 Attachment(s)
    • Replies: 0
    • Views: 2,038
    Excel Fox
    04-30-2011, 11:55 PM Go to last post

  11. Checking Table Exist in Access Database or Not

    Started by littleiitin, 11-16-2011 09:09 AM
    access, database table, exist table
    • Replies: 1
    • Views: 2,791
    LalitPandey87
    11-16-2011, 04:32 PM Go to last post

  12. Class Objects Created Using the CreateObject Method That Employs Late Binding

    Started by Excel Fox, 08-16-2011 12:38 PM
    createobject list, late binding objects
    • Replies: 0
    • Views: 2,485
    Excel Fox
    08-16-2011, 12:38 PM Go to last post

  13. Class Stuff: VBA Custom Classes & Objects, Class Modules

    Started by DocAElstein, 12-26-2018 04:27 PM
    2 Pages •
    1 2
    12 Attachment(s)
    • Replies: 17
    • Views: 66,771
    DocAElstein
    12-26-2018, 04:35 PM Go to last post

  14. Lightbulb Consolidate multiple workbooks from a folder into one master file VBA

    Started by Admin, 09-22-2012 10:26 AM
    consolidate, folder, merge, multiple workbooks, vba
    • Replies: 4
    • Views: 9,146
    Admin
    02-26-2013, 09:00 PM Go to last post

  15. Convert Text In YYYYMMDD Format To Date Format

    Started by S M C, 05-16-2011 03:38 PM
    yyyymmdd to date
    • Replies: 1
    • Views: 11,147
    Rick Rothstein
    02-28-2012, 12:04 AM Go to last post

  16. Converting a Column Number to a Column Letter

    Started by Rasm, 04-07-2011 03:26 AM
    column number to letter
    • Replies: 6
    • Views: 3,672
    Rick Rothstein
    12-17-2012, 02:29 AM Go to last post

  17. Lightbulb Copy/Paste Excel Range/Chart into Powerpoint VBA

    Started by Admin, 08-29-2012 02:30 PM
    chart, copy/paste, export, powerpoint, range, vba
    • Replies: 1
    • Views: 17,066
    LalitPandey87
    03-13-2014, 02:59 PM Go to last post

  18. Count Alpha In AlphaNumeric Text

    Started by S M C, 07-16-2011 08:21 AM
    count alpha alphanumeric
    • Replies: 1
    • Views: 1,921
    Admin
    07-19-2011, 02:32 AM Go to last post

  19. Count Files In A Folder VBA

    Started by Admin, 05-07-2011 10:57 PM
    count files in a folder
    • Replies: 0
    • Views: 6,280
    Admin
    05-07-2011, 10:57 PM Go to last post

  20. Lightbulb Count words having more than one character in a cell

    Started by Admin, 09-30-2011 08:48 AM
    count characters, count words, evaluate, frequency
    • Replies: 3
    • Views: 2,813
    Rick Rothstein
    03-13-2012, 08:29 PM Go to last post
Page 1 of 6 123 ... LastLast

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules