##
25 posts tagged with excel *and* vba.

Displaying 1 through 25 of 25. Subscribe:

## Excel Filter: IF Statements and Concatenate

I'm trying to test if a a series of cells exist, and then concatenate the values that do exist with a paragraph I have. [more inside]

## Making Excel do stuff for me, automagically!

Where can I find snippets of vba macros that I can use/reuse? What are your favorite macros that you use and can't do without? [more inside]

## How can I get access to readyState 3 with VBA "AJAX"?

I'm writing some VBA code (in Excel) which uses a reference to

`Microsoft XML, v6.0`

, and creates a `MSXML2.XMLHTTP`

object.
I used the `clsXMLHttpMonitor`

example from this page as a starting-off point.
How can I access the response text when readyState = 3? [more inside]## Help this Mac user learn PC software for job hunt

How can I improve my computer skills for job hunt when I use a Mac and the software is for PC? [more inside]

## Method Range of Object Global failed

I'm starting to write some Excel-VBA Macros, but it seems I don't get some basic things. I tried this simple code: [more inside]

## Need VBA help to refresh and save worksheet.

Have Excel 2007. I would like to have a spreadsheet perform the following simple? tasks [more inside]

## Excel Macros For Dummies

Explain to me Excel macros and how I can learn to program them (assume that I know absolutely nothing, because that would be correct). [more inside]

## Trying to find Excel VBA code for "round dot" gridline.

Excel VBA question: help me insert a "round dot" gridline in my chart. [more inside]

## Using Excel to create the body of an Outlook e-mail

Complex Excel question - need to select a range of cells, based on the selection of a separate cell. But wait, it's more complicated than that! [more inside]

## Need help developing a Excel VBA Macro to Vaildate data entered into a textbox

Need help developing a Excel VBA Macro to Vaildate data entered into a textbox [more inside]

## MacgyverFilter: link sharing using MS Office

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]

## Know any good VBA tutorials?

Can you reccommend VBA tutorials, particularly for MS Excel 2007? [more inside]

## Excel Programming Book

Can anyone recommend a good book for medium-advanced level vba programming for Excel?

## Selecting range of data based on values in a particular column

ExcelFilter: How can I select a range of data using VBA in Excel based on the values in a particular column? [more inside]

## Code Execution has been interrupted

Code Execution has been interrupted:

Continue - End - Debug - Help

*Click Continue*

*Repeat Indefinitely*

Help?! [more inside]

Continue - End - Debug - Help

*Click Continue*

*Repeat Indefinitely*

Help?! [more inside]

## Excel Macro

Using Excel VBA, how to convert positive numbers to negative, and vice versa? [more inside]

## How to get around Excel macro warning.

How to bypass Excel macro warning or alternative to macro.
[more inside]

## Cruel by inevitable extinction of Excel monkeys

What to do about the inevitable irrelevance of my skill set? [more inside]

## Stumped by VBA-ising an array formula in Excel

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]

## Turning a complex Excel spreadsheet with VBA functions into an online app

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]

## Decimal seconds, please.

Microsoft Excel VBA question: Converting decimal degrees to degrees-minutes-seconds (DMS), with rounding customization. [more inside]

## Why is my excel VBA code execution randomly slowing down?

Sometimes excel VBA code executes very slow. Sometimes it's really fast. I can't seem to pinpoint why. [more inside]

## Excel Sheet Lockout

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]

## How to iterate through controls in VBA/Excel?

How do I loop through a bunch of controls using VBA in Excel 2003? [more inside]

## Oh. My. Code. Excel VBA Needs

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]

Page:
1