Overriding a cell value?

Microsoft Office Forums

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

Mark Forums Read

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 »

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
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 08:01 AM.