Applying a formula from a checkbox in VBA

jap7675 · #1 11-18-2015, 02:28 PM

Hi,

I've been struggling with this for a while now, so i realllyyyy hope someone can help!

I have this code

Private Sub CheckBox1_Click()
If OptionButton1.Value = True Then

Sheets("Sheet1").Select
Range("J4:J40").Select
Selection.FormulaArray = "=IFERROR(INDEX(C$2:C$14, SMALL(IF($B$2:$B$14=1, ROW($B$2:$B$14)-1),ROWS(G$2:G2))),"")"
Selection.Columns.AutoFit

ElseIf OptionButton1.Value = False Then
Range("J4:J40").Value = " "
End If

End Sub

Where I'm trying to get the formula perforned in cell J4. It just wont do it!
And I dont really get why!

Please Help

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Applying styles dynamically?	arkofcovenant	Mail Merge	1	05-08-2015 06:02 AM
applying a style in a new document	lihin	Word	1	12-13-2012 05:22 AM
Applying Header to certain pages	chloe.eloise	Word	2	05-16-2011 12:13 AM
Help applying different margins to different pages	kthomp	Word	0	06-18-2010 11:37 AM
Applying And Removing Letterhead	skoz55	Word	0	08-06-2009 10:22 PM