##
10 posts tagged with excel *and* visualbasic.

Displaying 1 through 10 of 10. 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]

## Help me use Excel to save my job

So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack.
I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]

## I have too many conditions for Excel

Using Excel 2000, I need to do conditional formatting with 5 options. This isn't possible with actual conditional formatting, but it is possible using Visual Basic. Unfortunately, I know nothing about Visual Basic. Specifics inside. [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]

## Help me make sense of excel and VB

I want to take a small worksheet I created in excel and turn it into a standalone application. How? [more inside]

## Decimal seconds, please.

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

## Can't calculate paired T-value in Visual Basic

Visual Basic and Excel: How do I replicate the results of excelâ€™s internal function for paired dual tailed t-test in Visual Basic. I tried and failed, where did I go wrong? [more inside]

## VB in the tree

vbFilter: Outputting results to a treeview object in Excel. [more inside]

## Carriage Returns in Excel

It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]

## Is there any way to make Excel macros less stupid?

Is there any way to make Excel macros less stupid? [MI] [more inside]

Page:
1