Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
Thank you Master.
Paano po kung gusto ko sya i-autosave sa source directory nya?
Sir Newbie lng
ask ko lng po kpg magtype ako ng khit anu kay Cell A2 tapos lalabas kay Cell B2 ung date if kelan ka ngtype kay Cell A2.
pde po b un?
pra po syang updating log file.
tnx po
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$2" Then
ThisWorkbook.Worksheets("Sheet1").Range("B2").Value = Now()
End If
End Sub
1. Open Microsoft Excel
2. Press ALT + F11
3. Sa kaliwa, Double Click Sheet1
4. i-paste ito :
Code:Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$2" Then ThisWorkbook.Worksheets("Sheet1").Range("B2").Value = Now() End If End Sub
5. Balik ka excel, magtype ka ngayon sa cell A2.
Sir
try ko if allowed kpg madaming cell kaso ndi pla pde.
bka po my praan na pde po sya sa mdaming cell.
salamat po ng marami. dagdag kaalaman.
Anu yung source directory.?
yun ba yung path kung san nakasave yung workbook.?
palitan mu lang code sa SaveAs.. yung path..
eto..
"C:\Users\" & Environ("USERNAME") & "\Desktop\" & ActiveSheet.Name & ".txt",
gawin mu ganito..
Thisworkbook.Path &"\" & ActiveSheet.Name & ".txt",
panong madaming cell? madaming cell na paglalagyan ng data? madaming cell na paglalagyan ng output?
give me an example ng "madaming cell" na sinasabi mo baka pwedeng gawan ng paraan.
Sir pki-check po ng attachment. salamat po ulit
parang ganito ang gusto mo mangyari?
Sa column N maglalagay ng data (dynamic ang range), so saang column ko ilalagay ung output? sa column V ba?
Yes Sir. Tama po kau.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("N4:N1048576")) Is Nothing Then
If ThisWorkbook.Worksheets("Sheet1").Range("N" & Target.Row).Value <> "" Then
ThisWorkbook.Worksheets("Sheet1").Range("V" & Target.Row).Value = Now()
Else
ThisWorkbook.Worksheets("Sheet1").Range("V" & Target.Row).Value = ""
End If
End If
End Sub
Overwrite mo yung luma.
Code:Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("N4:N1048576")) Is Nothing Then If ThisWorkbook.Worksheets("Sheet1").Range("N" & Target.Row).Value <> "" Then ThisWorkbook.Worksheets("Sheet1").Range("V" & Target.Row).Value = Now() Else ThisWorkbook.Worksheets("Sheet1").Range("V" & Target.Row).Value = "" End If End If End Sub
Hello guys ginawa ko lang tong thread para sa mga kasymb natin na need ng tulong about MS excel. mga reporting staff, encoders, data analyst, secrectary, or Ms excel systems. pasok po kayo dito. share tayo ng knowledge. i will provide tutorials too. believe me after learning this things after a month i got my promotion to go up another level from our company. so try it now. made your bosses like their jaws drop.
on my first example. you will see chart with controls like the picture below.if nagustohan nyo po. pwede nyo sya idownload sa baba.
View attachment 887637
here you will see conditional formatting with toggle.like the picture below.
View attachment 887650
now you will see a picture album using excel. but in this tutorial i'll give you an example of animal album.
View attachment 888228
in this picture you will see a chart that looks like a temperature. it would be helpful to a presentations with a sales and target sales.
View attachment 888874
now in this picture you will see a speedo meter chart with control. the tutorial was provided from the attachment.
View attachment 888895
at eto naman ang sample dashboards ko
sample 1
http://i.giphy.com/xTiTnzLUI4whphKpoc.gif
sample 2
http://i.giphy.com/3o85xkmN4eEdkNV6Zq.gif
digital clock by dhok si...
sana po magshare din ang iba,
grading system excel application upload by our contributors. http://www.symbianize.com/showthread.php?t=1132342&p=19858679&viewfull=1#post19858679
eto na po para yung iba di na masyado magtanong sa excel tricks. lalo na mga charts with controls. im giving you all this.
http://i.imgsafe.org/19867c1.jpg
Excel hacks.rar
eto po splitted into two parts. thanks to devildarkrs
part 1
http://www.symbianize.com/attachment.php?attachmentid=1043979&d=1436253924
part 2
http://www.symbianize.com/attachment.php?attachmentid=1043978&d=1436253924
credits to creator of the book.
HOW TO UNLOCK VBA PROJECT
credits goes to athenesia
Master tutulungan mo po ba ko sa excel file ko?