true power of MS excel. update: PowerBI

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials

sir, pag aralan mo to, parang malapit nato sa ina asam mo.hehehe... http://office.microsoft.com/en-001/excel-help/introduction-to-vlookup-RZ101862716.aspx?section=2

alam nyo guys mukang kailangan natin gumawa ng steps para gumawa ng application development eh. dapat meron din tayong sample ng inventory management, payroll management and book keeping management eh.

 

[dannyps2]

Re: MS excel we give solutions. formula, codes and tutorials

alam nyo guys mukang kailangan natin gumawa ng steps para gumawa ng application development eh. dapat meron din tayong sample ng inventory management, payroll management and book keeping management eh.

tama po kayo sir, cg simulan nyo na. mag suggest nalang kami kung may ma e dagdag. salamat po!

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials

tama po kayo sir, cg simulan nyo na. mag suggest nalang kami kung may ma e dagdag. salamat po!

mga bro pacheck na ng first page.

 

[s2pid4802]

Re: MS excel reportings, presentations, and vba helping thre

pa bm ulit ...............

 

[dannyps2]

Re: MS excel we give solutions. formula, codes and tutorials

mga bro pacheck na ng first page.

Pinag tyagaan talaga ni ts ang pag bigay ng info sa page1.
=========================================
May tanong ako sir, naka attach po yong file. ung list box gusto ko sana combobox ang gamitin, embis na listbox, pero di ko mapagana ang combobox. baka matulongan nyo ako sir..

salamat nga pala sa effort nyo.

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials

Pinag tyagaan talaga ni ts ang pag bigay ng info sa page1.
=========================================
May tanong ako sir, naka attach po yong file. ung list box gusto ko sana combobox ang gamitin, embis na listbox, pero di ko mapagana ang combobox. baka matulongan nyo ako sir..

salamat nga pala sa effort nyo.

ano ba use nito bro?pag kapili mo lalabas yung picture sa userform.ganto ba

private sub combobox1_change()
dim a as integer
dim pictfilename as string
dim picpath as string
for a = 7 to 13
   if combobox1 = cells(a, 4) then
     pictfilename = cells(a,7)
     picpath = pictfilename
end if
next
  if len(dir(picpath)) = 0 then
    msgbox picpath & " does not exist "
  else
    me.pic.picture = loadpicture(picpath)
    me.repaint
end if
end sub

di pa malinis yan. pwede pa umigsi yan. hehehe. alam ko naman di ka na bago dito eh.

 

[muthym]

Re: MS excel we give solutions. formula, codes and tutorials

Hello....


@dannyps2

Diba nakadefine sa listbox rowsource mo? Pagka-add mo ng combo box, ganun din gawin mo. tapos eto na yung code.

Private Sub ComboBox1_Change()
    Pic.Picture = LoadPicture(Range("d3").Value + ComboBox1.Text + ".jpg")
    Pic.PictureSizeMode = fmPictureSizeModeZoom ' you may omit this line para umigsi :) set mo na lang before run-time sa properties window.
End Sub

pa-tsek na lang kung gagana sa'yo...

- - - Updated - - -

o di kaya ito...

Private Sub ComboBox1_Change()
    Dim i As Integer
    i = ComboBox1.ListIndex
    Pic.Picture = LoadPicture(ComboBox1.List(i, 3))
    txtDesc = ComboBox1.List(i, 1)
    txtTitle = ComboBox1.List(i)
End Sub

 

[dannyps2]

Re: MS excel we give solutions. formula, codes and tutorials

working po sa akin mga suggestion code nyo, dami pala idea pwedi gawin..

salamat po sa inyo ts at muthym..

 

[johnrob17k]

Re: MS excel reportings, presentations, and vba helping thre

salamat d2 ah pa BM ako ah..

 

[muthym]

Re: MS excel we give solutions. formula, codes and tutorials

working po sa akin mga suggestion code nyo, dami pala idea pwedi gawin..

salamat po sa inyo ts at muthym..

Wala pong anuman.

Parang Math lang yan... Iisang problema, maraming solusyon. At ang mga tao ay iba-iba ang takbo ng utak kaya maraming lilitaw na ideya.

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials

Wala pong anuman.

Parang Math lang yan... Iisang problema, maraming solusyon. At ang mga tao ay iba-iba ang takbo ng utak kaya maraming lilitaw na ideya.

tama ka dyan bro. lahat may kanya kanyang diskarte.

 

[beauty and the beast]

Re: MS excel we give solutions. formula, codes and tutorials

Ito na ba yung tinatawag na macro? bookmark ko to...

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials

Ito na ba yung tinatawag na macro? bookmark ko to...

alin po ba?

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials

pa up lang mga boss

 

[c0deSeeker]

Re: MS excel we give solutions. formula, codes and tutorials

patulong naman mga boss newbie lang eh, kasi gusto ko mangyari may command button na mag copy ng mga shapes then clear button na mag clear ng kinoypa na mga shapes. Ito ngayon ang problem pag hit ko ng clear button yung original shapes yung nadedelete, hindi yung copied shapes. Dagdag ko na rin mga boss na before maexecute yung mga commands parang may security code muna na iinput. Salamat in advance

nakaattached po yung samples

 

[beauty and the beast]

Re: MS excel we give solutions. formula, codes and tutorials

alin po ba?

wala TS binabasa ko pa lang.... Nice thread TS. Bago lang pala to, nung February lang.. hindi ko kasi nakikita to dati eh..

Macro programming
VB programming

- - - Updated - - -

Very nice yung idea na moving gif yung ginamit... paturo naman TS kung paano mo ginawa yung gif... saka ilang pictures yung laman nung gif.

Nakakainspire naman...


- - - Updated - - -

I am interested in this kind of programming. I believe its easier kasi wala siyang madaming kaekekan like you have to install plugins, setting up your computer or netwrok and downloading different dlls and separate third party softwares. Yun lang kasi it is something not popular sa college namin dati, but i became aware of it when a friend of mine nagkawork sa manila as macro programmer. Prior to this I don’t have idea how the GUI looks like, or what kind of user would like this. I tried searching over internet but haven't seen very useful/interesting information, (or maybe I just don't know the right term to use.) That was years ago…


- - - Updated - - -

➤ Version of Excel: Will your Excel application be used with Excel 2013 only? With Excel 2007
and later? What about Excel 2003 and earlier versions? Will your application also be run on a

This came from the book of John Walkenbach “Excel 2013 Power Programming with VBA”

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials

patulong naman mga boss newbie lang eh, kasi gusto ko mangyari may command button na mag copy ng mga shapes then clear button na mag clear ng kinoypa na mga shapes. Ito ngayon ang problem pag hit ko ng clear button yung original shapes yung nadedelete, hindi yung copied shapes. Dagdag ko na rin mga boss na before maexecute yung mga commands parang may security code muna na iinput. Salamat in advance

nakaattached po yung samples

View attachment 171579

ganto ba bro? part of method yung paghide ng button. pero madami pwede diskarte dyan. kaw nalang bahala.

- - - Updated - - -

wala TS binabasa ko pa lang.... Nice thread TS. Bago lang pala to, nung February lang.. hindi ko kasi nakikita to dati eh..

Macro programming
VB programming

- - - Updated - - -

Very nice yung idea na moving gif yung ginamit... paturo naman TS kung paano mo ginawa yung gif... saka ilang pictures yung laman nung gif.

Nakakainspire naman...


- - - Updated - - -

I am interested in this kind of programming. I believe its easier kasi wala siyang madaming kaekekan like you have to install plugins, setting up your computer or netwrok and downloading different dlls and separate third party softwares. Yun lang kasi it is something not popular sa college namin dati, but i became aware of it when a friend of mine nagkawork sa manila as macro programmer. Prior to this I don’t have idea how the GUI looks like, or what kind of user would like this. I tried searching over internet but haven't seen very useful/interesting information, (or maybe I just don't know the right term to use.) That was years ago…


- - - Updated - - -



This came from the book of John Walkenbach “Excel 2013 Power Programming with VBA”

tama ka. among all language eto ang pinakamadali. madali lang gumawa ng GUI. para ka lang gumamit ng dream weaver check mo to.

View attachment 171582​

kinarir ko talaga to dahil most businessman need this and offices too. and i dont think mawawala ang excel for the next 20 years.

tungkol naman sa moving pictures. may recorder kasi ako ng gif.

yes from John Walkenbach ko kinuha yung guides and tips ng pagawa ng applications. kaya binigay ko yung credits sa kanya.

 

[dannyps2]

Re: MS excel we give solutions. formula, codes and tutorials

sir, ask ako idea dito sa ganiwa kung employee log-in log-out...
Problem: Kung minsan Nag log-in sila 6/1/2014 8:00AM----> Log-Out 6/2/2014 8:00AM, kinabukasan pa. ina abut tuloy ng 23 hours in total dito sa formula ko. gusto ko sana 8 hours parin ang counting kahit ganyan sila mag log out. need ko idea dito sir..

salamat po at good Morning sa inyo..

 

[madhatter89]

Re: MS excel we give solutions. formula, codes and tutorials

maganda to boss..

actually im looking for an excel formula o format for grading system ung sa BEC..

Thanks !

 

[shinji111hirako]

Re: MS excel reportings, presentations, and vba helping thre

pasali din ako dito ser!