Sheet Change help

fdavidgolf

New Member
Joined
Apr 23, 2002
Messages
26
Hi!

I used a worksheet change and I get in the routine but Target.Column does not work.
What do I use to address the cells?
I want column E to be a formula :
Column D * Column C.

Private Sub Workbook_SheetChange(ByVal AssetInventory As Object, _
ByVal Source As Range
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
On 2002-04-25 08:38, fdavidgolf wrote:
Hi!

I used a worksheet change and I get in the routine but Target.Column does not work.
What do I use to address the cells?
I want column E to be a formula :
Column D * Column C.

Private Sub Workbook_SheetChange(ByVal AssetInventory As Object, _
ByVal Source As Range

Hi Frank
Please explain further exactly what it is you
want to happen via this event?
 
Upvote 0
Columns are:
Asset ID, Description, Unit Price, Quantity, Extended Price, and Location.

Originally, I wanted Extended Price to be a formula Unit Price * Quantity, but I didn't want to fill in the formula, because the $0.00 was displayed. Now, I filled in the formula and hide the money by making the background and display color the same. Now, what I want to do is change the background when data is entered in the row.

Private Sub Workbook_SheetChange(ByVal AssetInventory As Object, _
ByVal Source As Range)

MsgBox "In Change ... " & ActiveCell.Rows.Address

- This displays correct address $E$17

If ActiveCell.Rows.Address = "$E$" & Range("E" & Right(ActiveCell.Rows.Address, 2)) Then
------ this doesn't execute
Module3.ShowExtPrice
Else
MsgBox "$E$" & Range("E" & Right(ActiveCell.Rows.Address, 2))
---- This display $E$extended price money like $E$2200 for Unit Price of $1100 and Quantity of 2

End If

End Sub


-----

I prefer the formula be used in column E automatically. Any suggestions?
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,273
Members
448,559
Latest member
MrPJ_Harper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top