Lowyat.NET: Latest topics by kennywai

[WTB] nerf retaliator faulty

kennywai — Mon, 11 Jun 2018 09:37:14 +0800

Item(s): nerf retaliator faulty any colour

Package includes: just the shell will do, okay with on mags

Price: any[/color]

[b]Warranty: none

Dealing method: COD penang / postage

Location: penang

Contact method/details: 0164215485
---

Item(s) conditions:used / faulty

Picture:

Reason for sale:

WTB ASUS ROG Strix GTX 1060

kennywai — Tue, 26 Dec 2017 13:37:27 +0800

Item(s): as title

Package includes: GC

Price: offer me (!!!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)

Warranty:

Dealing method: COD / CC / GIRO

Location: Penang

Contact method/details: PM
---

Item(s) conditions:

Picture:

Reason for sale:

-SOLD- Cooler Master GXII 750W 80 Plus Bronze

kennywai — Thu, 23 Jan 2014 01:33:44 +0800

product link : CM GXII 750W

Features :
1. Patented Non-stop USB Power - USB Charging when device PC is off
2. 4x PCIe 4+4 pins ( SLi, CFX ready )
3. 9x SATA, 3x Molex, 1x Floppy
4. 80 Plus Bronze Certification

CM GXII 750W review from fellow forumer

Used 2-week
Include original box, original receipt for warranty claim, shop location is in Bukit Jambul

Warranty countdown : ( CM warranty ) ; "1st year free, 4 years pay only courier charges"
5 years
4 years 11 months
4 years 10 months

Receipt will be shown upon request.

Reason for sale : quit PC gaming, focusing on PlayStation

Contact method
0164215485
LYN PM
COD Location : Penang

-BOUGHT- Used SLi-able mobo

kennywai — Wed, 22 Jan 2014 12:56:20 +0800

need find a SLi-able mobo for my available procs

either
1. AMD Phenom X4 ( AM2+ socket )
2. Clarkdale i5 ( 1156 socket )

Contact
016-4215485
kennywai25@gmail.com
LYN PM

-SOLD- Palit GTX260 216SP HDMI

kennywai — Sat, 18 Jan 2014 05:59:46 +0800

As title

Palit GTX260 with 216SP
product link :Palit GTX 260 216 SP

Recently cleaned fans and reapplied thermal paste
HDMI, DVI, VGA output ports
Able to play current gen games in mid to high settings

Reason for sale : quit PC gaming; focus on PlayStation

Contact method :
016-4215485
kennywai25@gmail.com
LYN PM
location : PG

[WTB] nyko power grip or PDP trigger grip

kennywai — Wed, 15 Jan 2014 13:42:00 +0800

As title,
Working condition.

COD location : PG
LYN PM / whatsapp 016-4215485

-SOLD- ori non modded PS3 Super Slim 500GB set

kennywai — Thu, 12 Dec 2013 18:47:23 +0800

Hi,

Selling 1 unit of non-modded ori firmware 4.50 PS3 Super Slim 500GB
Bought in July 2013, with 6 months of SONY MY warranty remaining; receipt included

Please see further photos below :

» Click to show Spoiler - click again to hide... «

Full set consists of following :
1x PS3 Super Slim 500GB CECH-4k RM1199
1x SONY PS3 Super Slim Vertical Stand RM79
2x original DualShock 3 Controller ( Black and Blue ) RM150
1x Power Cord
1x original micro USB charging cable
1x HDMI Cable from SONY
1x NYKO Charge Base 3 RM99
1x PS3 Box with all original documentation
1x sealed original component video cable
21x "used, like new" Blu-ray disc games; photo above

» Click to show Spoiler - click again to hide... «

Method of contact : PM me; Kenny
email : kennywai25@gmail.com
Viber/LINE/iMessage/WhatsApp/SMS/Call : 016-4215485
COD location : PG

Price : Offer me. Looking to sell together with all games, not worth individually anyway, can nego further if take all games.

Thanks !!

(WTA) upgrade PC spec

Thu, 01 Jan 1970 07:30:00 +0800

-CLOSED- upgrade GC

kennywai — Thu, 28 Nov 2013 09:41:48 +0800

Started this thread months ago, currently running a Palit GTX260 216SP,
Would like to know whats the next GC to get if i wanna upgrade, just the GC, PC specs below fyi

PSU - 750W
CPU - AMD Phenom 9750
RAM - 4GB 800Mhz DDR2
Mobo - 1x PCIe 2.0 x16

» Click to show Spoiler - click again to hide... «

-SOLD- PS Move Charging station

kennywai — Tue, 27 Aug 2013 10:23:42 +0800

Hi all,

Selling 1 unit of BRAND NEW Sony PS Move Charging Station
just unboxed to take photo and view the contents.

reason for sale is cos i sold my old PS Move Sharpshooter in the spoiler below
offer me your price, cheaper if COD in Penang.
photos :

» Click to show Spoiler - click again to hide... «

contact : Kenny, whatsapp @ 016-4215485 or PM

------------------------------------------------------------------------------------------------------------

» Click to show Spoiler - click again to hide... «

[WTS] PSV 1000 Black + 16GB MMC

kennywai — Wed, 14 Aug 2013 13:17:44 +0800

[Want to Buy]
PS4
-Wolfenstein: The New Order
-Bloodborne
-The Division

PS3
-Far Cry 3

[Want to Sell / Want To Trade]
PS4
-PSV 1000 Black + 16GB MMC
-Diablo 3 : Reaper of Souls

PS3
-None

- Tomb Raider R3 PS4 - sold to blurkia
- NFS:Rivals R1 PS4 - sold to Oblivionz
-inFAMOUS:Second Son R3 PS4 - sold to JH Game Shop
- Killzone : ShadowFall R3 PS4 - sold to dragontongue88
- AC4 : Black Flag R3 PS4 - sold to night_wolf_in
- AC:ET and AC3:WE PS3 - sold to samson
-Injustice: Collector's Edition Steelbook PS3 - sold to crawlerz

Successful tradelist

» Click to show Spoiler - click again to hide... «

Contact method
Kenny Wai
HP : 016-4215485 ( whatsapp, viber, SMS )
email : kennywai25@gmail.com
COD anywhere in PG island, poslaju elsewhere

-BOUGHT- Pulse Elite Wireless Headset

kennywai — Tue, 09 Jul 2013 22:53:17 +0800

As title,
Working condition.

COD location : PG
LYN PM / whatsapp 016-4215485

-SOLD- HP mini 210-1073TU

kennywai — Sat, 02 Jun 2012 00:40:17 +0800

SOLD, TY for looking

Item(s): 2nd unit of HP Mini 210-1073TU Netbook - battery dead

minimal footprint, low budget and cheap solution
for turning your TV into smart TV,
or for Home Theater PC to stream content from internet / external HDD
or video chat on the TV with webcam

Specs that matters :
- Intel Atom N450 Processor 1.66 Ghz
- 250GB (7200rpm) Hard Drive
- 5-in-1 Digital Media Reader
- Webcam
- VGA out
- 3x USB2.0 ports

Whats inside:
- HP Mini 210-1073TU Netbook
- Power Cable and Adapter
- 1 netbook sleeve
- Everything that came with the box

Other details:
- RM350 nego ; cheaper if COD in Penang
- COD / courier ( buyer bear risk )
- PM or Whatsapp @ 016-4215485
- Age : 3 yrs

Item(s) conditions:
- 8/10 ; battery dead, but will be given together

Picture:

» Click to show Spoiler - click again to hide... «

Reason for sale:
- Underutilized 5th laptop, have PS3 as my media center

some questions

kennywai — Thu, 26 Apr 2012 21:19:26 +0800

hi all ice sifus

wanna ask something here

after seeking some shop opinion,

they normally recommend changing to the component speaker set first
FYI, i already have a RM300+ pioneer HU, not sure what model, but purchased few yrs back. have aux input, no usb

wanna ask, is it we gain the most from changing the speaker ? currently all stock except HU.

also, is audioquad a good brand ? the shop was recommending this component set @ RM390 including installation. The set has a very plastic look and feel compared to some other brands the other bros are offering in garage sales but im unable to order from them cos im in PG.

some help, opinion, advise is needed and many thanks.

lastly, any recommended ICE shops in PG ?

Vb macro hiding rows

kennywai — Mon, 07 Feb 2011 11:38:12 +0800

How do I hide rows that are not selected ?

The user may also input more than 1 system / day
for example, he wishes to check s1 , s3 and s7 and d3,d9 and d12

Below is the code to select the rows that are needed in the graph

My approach is to plot everything and then hide the UN-NEEDED rows and columns in order to obtain my final graph

CODE

Sub ifelseloop1()

Dim target As String

system1 = InputBox("Which SUT would you like to check ? Please enter s1... s7")
days1 = InputBox("Which days would you like to check ? Please enter d1... d13")

If (system1) = "s1" Then
colmuns("B").Select
ElseIf (system1) = "s2" Then
Columns("C").Select
ElseIf (system1) = "s3" Then
Columns("D").Select
ElseIf (system1) = "s4" Then
Columns("E").Select
ElseIf (system1) = "s5" Then
Columns("F").Select
ElseIf (system1) = "s6" Then
Columns("G").Select
ElseIf (system1) = "s7" Then
Columns("H").Select
ElseIf (system1) = "s8" Then
Columns("I").Select
ElseIf (system1) = "s9" Then
Columns("J").Select
End If

If (days1) = "d1" Then
Rows("2").Select
ElseIf (days1) = "d2" Then
Rows("3").Select
ElseIf (days1) = "d3" Then
Rows("4").Select
ElseIf (days1) = "d4" Then
Rows("5").Select
ElseIf (days1) = "d5" Then
Rows("6").Select
ElseIf (days1) = "d6" Then
Rows("7").Select
ElseIf (days1) = "d7" Then
Rows("8").Select
ElseIf (days1) = "d8" Then
Rows("9").Select
ElseIf (days1) = "d9" Then
Rows("10").Select
ElseIf (days1) = "d10" Then
Rows("11").Select
ElseIf (days1) = "d11" Then
Rows("12").Select
ElseIf (days1) = "d12" Then
Rows("13").Select
ElseIf (days1) = "d13" Then
Rows("14").Select
ElseIf (days1) = "d14" Then
Rows("15").Select
End If

Range("B2").Select
Selection.CurrentRegion.Select
myRange = Selection.Address
mysheetname = ActiveSheet.Name
Charts.Add
Application.CutCopyMode = False
ActiveChart.ChartWizard _
Source:=Sheets(mysheetname).Range(myRange), _
Gallery:=xlColumnsClustered, Format:=4, PlotBy:=xlRows, _
CategoryLabels:=1, SeriesLabels:=1, HasLegend:=1, _
Title:="", CategoryTitle:="", _
ValueTitle:="", ExtraTitle:=""

ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"

Thanks.

simple excel macro

kennywai — Wed, 02 Feb 2011 19:24:20 +0800

Hi all,

Happy CNY !

i need some help here trying to hide columns and rows that are not required by the user.

An input box will prompt the user for which columns and rows he would like to remain ( keep visible )
The macro will have to hide those that are not selected

My question is how to tell the macro which rows / columns ( non-contiguous ) are unneeded and how to write the syntax

CODE

rows1 = InputBox("Which rows to hide")
range(XXX).Select
Selection.EntireRow.Hidden = True

columns1 = InputBox("Which columns to hide")
range(XXX).Select
Selection.EntireColumns.Hidden = True

excel macro help

kennywai — Fri, 28 Jan 2011 15:08:41 +0800

Hi all excel gurus

Currently working on a macro that prompts the user for the input for the ranges to be plotted in the graph.

The picture below is for your understanding of my problem.

For example, if the user inputs "D5,D7,D11" via the input box, assigned to myXData and "S3,S4,S7" via the input box , assigned to myYData.

The macro should plot the graph based on values highlighted in GREEN with the appropriate series names and labels.

The macro should plot the graph something like this.

CODE

Sub x()

Dim myXData As range
Dim myYData As range

On Error Resume Next

Set myXData = Application.InputBox( _
Prompt:="Select Days to Display.", _
Title:="Select Days", Type:=8)
Set myYData = Application.InputBox( _
Prompt:="Select Systems to Display.", _
Title:="Select System", Type:=8)

myXData.Select
myYData.Select

Charts.Add
ActiveChart.ChartType = xlColumnClustered
'ActiveChart.SetSourceData Source:=Sheets("Sheet1").range(x, [y])
ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"

With ActiveChart
.Location Where:=xlLocationAsObject, Name:="Sheet1"
.HasTitle = True
.ChartTitle.Characters.Text = "Values of System"
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).HasTitle = False
.Export "C:\mychart.png"
End With

End Sub

Thanks for any help offered in advance

[addedon]January 31, 2011, 1:46 pm[/addedon]still need help here please