Overriding a cell value?

Microsoft Office Forums

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Overriding a cell value?

Prev

Previous Post

Next Post

Next

#1

Old

04-02-2017, 07:19 PM

Cyberseeker Cyberseeker is offline

Cyberseeker is offline

Overriding a cell value?

Windows 10 Overriding a cell value?

Overriding a cell value?

Office 2010 32bit

Advanced Beginner

Overriding a cell value?

Join Date: Jun 2016

Posts: 44

Cyberseeker is on a distinguished road

Default

Overriding a cell value?

I have a cell (B16) which has its content placed into it by the following macro:

Code:

If xferArray(14) <> 0 Then Cells(16, 2).Value = xferArray(14)
Else: Cells(20, 2).Value = ""
End If

However, in some instances I may wish to override it, so my cell has the code:

Code:

=IF(Inv_override,"",B16)

As with many of my bright ideas, it doesn't work.

Im guessing that a small adjustment to my code will do the trick, but what? Can someone help?

Reply With Quote

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow	FUGMAN	Excel Programming	7	02-05-2017 08:37 AM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
Data validation,force cell to be filed with number if respective cell is not empty	nicholes	Excel Programming	0	08-01-2015 09:08 AM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:23 PM.