About Us

punking315

thanks for the nonsense

"Don Guillett" wrote:

This was asked and answered in a previous post.

Private Sub Worksheet_change(ByVal Target As Range)
If Target.Address = Cells(5, 2).Address Then
With Range("saltboxroofing").Font
..Color = vbBlack
If UCase(Target) = "GABLE" Then .Color = vbWhite
End With
End If
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"punking315" wrote in message
...
using vba.... what's the best way to change several cells based upon the
value of one cell. I know to a seasoned programmer the following attempt
is
laughable but bear with me, here is the code I'm wrestling with:

Public Sub worksheet_calculate(ByVal Target As Range)
If Range("select_type").Text = "gable" Then
Range("gableroofing_value").Value = Val(Range("L83"))
Else
If Range("select_type").Text = "saltbox" Then
Range("gableroofing_value").Value = ""

End If
End If
End Sub

Private Sub worksheet_calculate()

If Range("select_type").Text = "gable" Then
Range("saltboxroofing_value").Value = ""

Else
If Range("select_type").Text = "saltbox" Then
Range("saltboxroofing_value").Value = (Val(Cells(85, 12)) + Val(Cells(86,
12)))
Else
End If
End If

End Sub

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("select_type").Text = "gable" Then
Range("saltboxroofing").Font.Color = RGB(255, 255, 255)
Else
If Range("select_type").Text = "saltbox" Then
Range("saltboxroofing").Font.Color = RGB(0, 0, 0)
Else
End If
End If
End Sub

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change drop down list in one cell based on values in other cells	Hemi	Excel Discussion (Misc queries)	3	April 5th 23 02:48 PM
In excel change color of a range of cells based on a cell value	kwitt	Excel Worksheet Functions	1	November 18th 09 07:20 PM
Change cell background based on multiple cells	[email protected]	Excel Worksheet Functions	2	July 25th 07 05:03 PM
Is it possible to change colors of cells based on value in cell (.	LC	Excel Worksheet Functions	3	January 14th 05 05:27 AM
Change the colour of a bunch of cells, based on one cell.	Craig & Co.	Excel Programming	2	October 14th 04 06:28 AM

Menu

About Us