Need help developing a Excel VBA Macro to Vaildate data entered into a textbox [more inside]
posted by complience on Nov 25, 2009 - 4 answers

Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
posted by Monday, stony Monday on Nov 19, 2009 - 7 answers

Can you reccommend VBA tutorials, particularly for MS Excel 2007? [more inside]
posted by Librarygeek on Oct 19, 2009 - 1 answer

Can anyone recommend a good book for medium-advanced level vba programming for Excel?
posted by Miss Otis' Egrets on Aug 4, 2009 - 0 answers

ExcelFilter: How can I select a range of data using VBA in Excel based on the values in a particular column? [more inside]
posted by squorch on Jan 29, 2009 - 3 answers

Code Execution has been interrupted:
Continue - End - Debug - Help
*Click Continue*

*Repeat Indefinitely*
Help?! [more inside]
posted by johnstein on Jan 19, 2009 - 6 answers

Using Excel VBA, how to convert positive numbers to negative, and vice versa? [more inside]
posted by yezimary on Jan 7, 2009 - 16 answers

How to bypass Excel macro warning or alternative to macro. [more inside]
posted by emjay on Nov 4, 2008 - 13 answers

What to do about the inevitable irrelevance of my skill set? [more inside]
posted by anonymous on Nov 3, 2008 - 11 answers

How to do a VBA version of the following array formula in Excel? The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA: {="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)} [more inside]
posted by Mokusatsu on Oct 17, 2008 - 3 answers

I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA? [more inside]
posted by Mokusatsu on Sep 12, 2008 - 2 answers

Microsoft Excel VBA question: Converting decimal degrees to degrees-minutes-seconds (DMS), with rounding customization. [more inside]
posted by dondiego87 on Jun 10, 2008 - 5 answers

Sometimes excel VBA code executes very slow. Sometimes it's really fast. I can't seem to pinpoint why. [more inside]
posted by johnstein on May 21, 2008 - 8 answers

I have a spreadsheet that I want to lock after a certain amount of data is entered. It needs to be an auto lockout as I cannot count on the user to stop entering data after a certain point. MI [more inside]
posted by lampshade on Nov 23, 2007 - 2 answers

How do I loop through a bunch of controls using VBA in Excel 2003? [more inside]
posted by apark on Feb 22, 2007 - 4 answers

I've created a button in Excel 2002 that runs some VBA when clicked. Works great. I've emailed the spreadsheet home and opened it with Excel 97 and clicking does nothing. When I run the subroutine from VBA editor, it works fine. So, what gives? Why won't this work in Excel 97 and what can I change so that it will run in Excel 97 and beyond? I've pasted the subroutine into the Extended box. Oh, and I'm really an infant with this, so please try and communicate on that level. [more inside]
posted by kc0dxh on Sep 8, 2006 - 11 answers