Lowyat.NET: Latest topics by chng7

[SOLD] Kenwood DDX715WBT -Toyota

chng7 — Sat, 09 Jun 2018 23:20:39 +0800

Item(s):
Kenwood DDX-715WBT [SOLD]

Package includes:
Headunit itself
Toyota harness - to avoid original wire cutting, hence prevent warranty void
Toyota Vios NCP150 headunit panel
&
all necessary cables

Price: (!!!NOTICE!!!: Sellers are required to display the exact selling prices of their products. Failure to do so will result in the deletion of the topic)
RM850 negotiable

Warranty:
original warranty over
1 week warranty from me

Dealing method:
COD

Location:
Klang Valley or KL

Contact method/details:
PM me and we'll chat through preferred method

---

Item(s) conditions:
Item like new. Installed 2 years ago and treated like a baby

Picture:
Pictures can be sent through email or whatsapp upon request.

Reason for sale:
Change Car

Extra - Original car sound quality improves even with original speakers. Extensive equalizer settings allow user to tweak the sound to suit the ears.
Of course, nothing beats upgraded speakers and amplified system la.

[SOLD]Breville Smart Grinder BCG800

chng7 — Tue, 03 Jun 2014 23:13:59 +0800

Item(s):
Breville Smart Grinder BCG800

Package includes:
Everything that comes with the grinder, 2Xportafilter holder, container etc etc

Price:
RM800.00 firm

Warranty:
until May 2014

Dealing method:
COD

Location of seller:
Klang Valley, Subang, Shah Alam, KL, Puchong, PJ

Contact method/details:
PM, 012-seven-two-seven5039

Age of item:
used for 2 weeks, minimal usage

---

Item(s) conditions:
9.99/10

Picture:
https://www.google.com.my/url?sa=i&rct=j&q=...402626918365292

Reason for sale:
Upgrade

This item is perfect for home baristas who wish to have more flexibility in coffee making, either tired of using manual grinder or tired of getting inconsistent results due to inconsistent grind size using lower end grinders and for those who are sick of stale, bitter pre-ground coffee.
Silent operation, dosing is pretty accurate, grind size is perfect, even for bottomless portafilter extractions.

[WTS] QMax PC cable & Hot Inazma

chng7 — Sun, 09 Mar 2014 21:39:20 +0800

Item(s):
1. QMax 2+1 cable with Photoconductor Cable
2. Hot Inazma Type LR Voltage Stabilizer

Package includes:
Complete package of the items mentioned above

Price:

Price dropped to RM250 for both items.

Warranty:
Nil.

Dealing method:
COD Klang Valley

Location of seller:
Klang, PJ, Subang, Sunway, KL, Klang Valley in general

Contact method/details:
PM

Age of item:
1. 2 years
2. 1 year +

---

Item(s) conditions:
Both items in working condition
1. Fuse intact
2. LED still lights up

Picture:
[url=https://lh4.googleusercontent.com/-v7XN4LAQcuc/VO2bY8k901I/AAAAAAAAA4s/6L8Wl_vEhN8/w542-h723-no/20140309_212537.jpg[/url]
[url=https://lh3.googleusercontent.com/AzrKmSIRhrTIF_qgYHNwdXfyte2a_HTS7mTTlE5U3Oo=w158-h210-p-no[/url]
[url=https://lh3.googleusercontent.com/bpaQA_a7Xz6ZvBY6oQhBcmLPRrtvcjbbc8Kp8PjBcIA=w276-h207-p-no[/url]

Reason for sale:
De-mod and sell car.

Questions welcomed

[SOLVED] VBA & Macro at Excel 2010

chng7 — Thu, 29 Nov 2012 16:15:07 +0800

Hi all, I'm a newbie in Excel Macro or VB, probably only one week into looking at this.

Basically I have two worksheets, one for project costing/budgeting and the other for quotation.
Now, my budgeting sheet has ALL items, but not necessarily all items are to be quoted, thus, column 9 for the unquoted items are 0. This is because everything in the budgeting sheet is automated based on human input in the first "Info Sheet" that I have also created.
So, I wish to have a macro working to copy all the quoted items in column 3 when column 9>0 from worksheet "Budgeting" to "Quotation". Other than these items, just do nothing.
This is what I have for now, it's just the first half, not even sure whether this is the right way

Sub transfer()

checkkclm = 9
copyclm = 3
startrow = 12
endrow = 195

For rowcnt = startrow To endrow
Sheets("Budgeting").Activate
If Cells(rowcnt, checkkclm).Value > 0 Then
Cells(rowcnt, copyclm).Copy
End If

Next rowcnt

End Sub

It's ok which ever column that is pasted in the "quotation" page. I can edit that later.

Any help will be appreciated.

(Closed)VBA & Macro at Excel 2010

chng7 — Thu, 29 Nov 2012 15:58:49 +0800