Inputting Formulas into cells using VBA

VBA Noob, Thanks for the response. See bolded comments below.

Is the trigger a formula or a by the user changing A7. If it's a user change it works for me

-trigger is user-initiated. They will be selecting a 'string' from a drop down list in A7.

Try adding this to the start

Please Login or Register  to view this content.

and this to the end

Please Login or Register  to view this content.

-added these lines. still dont see any formula populating the cells.

Also is the formula a custom User defined function ??

If so it might be worth posting that code

The formula I want to ppulate the cell is a UDF. Its a simple Case statement function used to evaluate the contents of A7 See below.

Function quicknetwork(quick1 As String)
Select Case quick1
Case "Show All Network Space Available"
quicknetwork = "ALL"
Case "Show All Network Space Utilized"
quicknetwork = "ALL"
Case "Show ALL Space Available"
quicknetwork = "ALL"
Case "Show ALL space Utilized"
quicknetwork = "ALL"
Case "Custom"
quicknetwork = ""
Case Else
quicknetwork = "NONE"
End Select
End Function

Let me know if you have any other ideas, suggestions.

Thanks for the attachment. I fooled around with it a bit and think I found whats causing the problem. I failed to mention (hadn't thought it relevant), that my A7 cell uses a list to validate entry options. The user will not be 'typing' in values to change this cells contents, but instead, is selecting one from a list. When A7s contents is changed using listed drop down values, the cell range wont take a formula. If I remove the 'list', it all works perfectly. Is there any way to get this working with a list? See my edited attachment below.

whoa..that was fast.

Nope. The cell Range that I'd like the formula (quicknetwork(a7), inserted into (C13-C27) can stay the same. Your previous spreadsheet demonstrated exactly what i need happening. Just need to make it happen with the change I made to the A7 cell in the spreadsheet I attached above :P. Have a look at it, you'll notice the "ALL, NONE, etc" values throughout C13-27 values dont change. Hope this makes sense.

Did you 'type' into A7 or did you use the drop down options? If I start by typing something into A7 and then press enter, the values in C13-27 change as required. If I use the mouse only and select a value for A7 using the pointer from the drop down items, the values in C13-27 dont change. I attached another spread with scenario where the values in C13-27 wont change if I select the contents of A7 using the mouse.