Presentations from SharePoint User Group Finland (Sep 8, 2010)

SharePoint User Group Finland published presentation materials from their September 8th meeting. Some examples how SharePoint can be utilized. Read and download the material.

Microsoft Dynamics CRM 2011 on YouTube

CRM Team has opened a YouTube channel for their video material; discussion, promos etc. Check Microsoft Dynamics CRM 2011 videos.

Excel VBA: Does the Cell or Range Have a Formula

Need to quicky check if a cell contains a formula? Use Range's HasFormula property:

Property definition

expression.HasFormula

• Expression = Range object
• Returns:
• True if all cells in range contain a formulss
• False if none contain formulas
• Null if some cells contain a formula 
• Read-only Variant

Use IsNull to check if the result is Null.

Example 1

Scenario
You have a column, where you want the user to have two options:

1. By default include a formula
2. Let the user enter a value manually

The formula is updated on Worksheet_Open or a button.

Solution 

' 

' Update only cells with formulas.

'

If ActiveSheet.Cells(Row, Column).HasFormula  Then

    ' Update or refresh your formula here.

End If

Example 2

See MSDN's HasFormula Property page for an example which recalculates the active worksheet if any cell in the currently selected range contains a formula.

Dynamics CRM 2011 Beta Is Here!

Beta for Dynamics CRM 2011 is now here, go and check it! My beta instance is already running :)

Excel 2007: Locating Data Entry Form Button

If you used the data entry form in Excel 2003, you might recall that it was easily available from the Data menu.

 

In Excel 2007 you won’t find a button anywhere within the ribbon. You will have to add it manually for example to the Quick Access Toolbar.

To get the Form button visible, follow these steps:

1. Click on the down arrow on the Quick Access Toolbar
2. Select More Commands

3. Select All Commands

4. Locate and select Form from the command list on the left

5. Click Add
6. Click OK
7. Now you can find the Form button at the end of the QAT

Excel Error: Error 800a0011 When Trying to Add a Control to UserForm

When adding a form control to a UserForm you might get the following error message:

Excel could not complete the operation due to error 800a0011

When this occurs, your VBA code is most likely currently in break mode.

Click OK in the error dialog and reset your VBA Editor (Run->Reset). Now you can add the form control to your UserForm.

Works at least for Excel 2007.

SP2010: Features and Their GUIDs

A list of SharePoint 2010 features with associated GUIDs is also available. Thanks Norwegian Information Worker Team!