Applying a formula from a checkbox in VBA

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Applying a formula from a checkbox in VBA

FAQ

Mark Forums Read

Thread Tools

Display Modes

11-18-2015, 10:46 PM

NoSparks

Windows 7 64bit Applying a formula from a checkbox in VBA

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Enter the formula you want in J4, with J4 the active cell, go to the vba immediate window and enter

Code:

? activecell.FormulaR1C1

hit enter and you'll see what the code is for that formula, except that the quotes need doubled up, have your code put this into J4 only, then use .autofill to copy down as necessary.

Tags

check box, iferror, index

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:42 PM.