true power of MS excel. update: PowerBI

[kirby21]

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

Thanks sir kirby! it works. May additional question po ako, paano ko po mapapalabas sa Listbox yung Columns A, C & E including the header that still based on 'WAITING FOR APPROVAL' status, bale hindi lng Column A yung maddisplay sa Listbox, Columns A, C & E na po including the header na din po.

Private Sub CommandButton1_Click()
lastrow = Sheets("sheet1").Cells(Cells.Rows.Count, 2).End(xlUp).Row
x = 0
For a = 2 To lastrow
If Cells(a, 6) = "WAITING FOR APPROVAL" Then
With ListBox1
    .AddItem
    .List(x, 0) = Cells(a, 1)
    .List(x, 2) = Cells(a, 3)
    .List(x, 4) = Cells(a, 5)
    x = x + 1
End With
End If
Next
End Sub

lagyan mo nalang ng label yung taas ng listbox mo bro. mas maganda tignan yun.

- - - Updated - - -

i really like this thread mukhang mapapadalas ako dito since i'm going to start working na , using Excel and Access.
I'm looking forward discussing some topics regarding this , Ts and TeamMates hello there

tambay ka lang dito bro.

 

[k0piko]

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

Private Sub CommandButton1_Click()
lastrow = Sheets("sheet1").Cells(Cells.Rows.Count, 2).End(xlUp).Row
x = 0
For a = 2 To lastrow
If Cells(a, 6) = "WAITING FOR APPROVAL" Then
With ListBox1
    .AddItem
    .List(x, 0) = Cells(a, 1)
    .List(x, 2) = Cells(a, 3)
    .List(x, 4) = Cells(a, 5)
    x = x + 1
End With
End If
Next
End Sub

lagyan mo nalang ng label yung taas ng listbox mo bro. mas maganda tignan yun.

.

Okay sige sir kirby. Paano naman po yung magddisplay yung 3 columns (Columns A, C & E)?

 

[knives645]

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

Hi, share ko lang tong example ko, baka lang wala pa nakakaalam.
how to populate a combo box with data, without VBA codes.

Sheet1 has a shape control, assigned with a macro to open the user form.
Sheet2 is the source of data for combo box.

You may check the properties of the comboBox, to see the changes I've made.

try nyo muna, hehe, mamaya ko explain kung pano, medyo busy pa sa work eh.

 

[kirby21]

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

Okay sige sir kirby. Paano naman po yung magddisplay yung 3 columns (Columns A, C & E)?

yan na yung code bro oh. 3 columns nalang yan. baka hindi mo napansin pero binawasan ko na yan.

- - - Updated - - -

Hi, share ko lang tong example ko, baka lang wala pa nakakaalam.
how to populate a combo box with data, without VBA codes.

Sheet1 has a shape control, assigned with a macro to open the user form.
Sheet2 is the source of data for combo box.

You may check the properties of the comboBox, to see the changes I've made.

try nyo muna, hehe, mamaya ko explain kung pano, medyo busy pa sa work eh.


http://www.symbianize.com/attachment.php?attachmentid=919874&stc=1&d=1400128296

thank you pre. ok yan.

 

[dannyps2]

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

i really like this thread mukhang mapapadalas ako dito since i'm going to start working na , using Excel and Access.
I'm looking forward discussing some topics regarding this , Ts and TeamMates hello there

oo, ganda talaga dito sir, dito na ako lagi tuma tambay nawala tuloy hilig ko sa pr****n dahil sa thread nato napa paisip kasi lagi..

 

[kirby21]

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

oo, ganda talaga dito sir, dito na ako lagi tuma tambay nawala tuloy hilig ko sa pr****n dahil sa thread nato napa paisip kasi lagi..

dito kasi para tayong nagchechess. magiisip ka ng magiisip.

 

[seventhofjune]

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

Phelp TS. e2 n yung problem ko. sa range a1 nandun yung sentence. gusto ko sa range a2 makuha yung ck amt. Pwede po paki gawa ng macro. Salamat.

 

[Ninetailedfox]

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

pa tamabay ako ts ha.. thanks sa thread na to

 

[winxlip]

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

salamat dito boss!!!

 

[JHAS0912]

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

sir.. halimaw din ako sa ms excel.. bka pede tayu magtulungan para kumita ng konti..

 

[mharbydoll]

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

Wow. Astig ka TS!

 

[votit2]

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

pa BM muna TS ..thanks

 

[kirby21]

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

pa tamabay ako ts ha.. thanks sa thread na to

sure. yun lang pala eh.

- - - Updated - - -

salamat dito boss!!!

balik ka lang,.

- - - Updated - - -

sir.. halimaw din ako sa ms excel.. bka pede tayu magtulungan para kumita ng konti..

talaga? hehehe. la ka ba sideline? or meron ka ba mga clietns?ano ba work mo?

- - - Updated - - -

Wow. Astig ka TS!

marunong lang ma'am.

- - - Updated - - -

pa BM muna TS ..thanks

tambay ka na din.

 

[berdhaws]

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

Releasing at receiving lang ang kailangan nyan sir.

parang ganito..

Hirap malagay nung code boss.. dko alam ggwin. .haha

 

[kirby21]

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

Phelp TS. e2 n yung problem ko. sa range a1 nandun yung sentence. gusto ko sa range a2 makuha yung ck amt. Pwede po paki gawa ng macro. Salamat.

fixed ba yung length ng width mo? pwede mo dagdagan kahit 10 rows?

 

[seventhofjune]

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

fixed ba yung length ng width mo? pwede mo dagdagan kahit 10 rows?

d sya fixed TS. Mnsan maikli lng yung sntence.

 

[kirby21]

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

d sya fixed TS. Mnsan maikli lng yung sntence.

pwede ka ba magbigay ng kahit sampu?

 

[dannyps2]

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

Hirap malagay nung code boss.. dko alam ggwin. .haha

sir suggestion ko lang, mag simula ka mag design ng userform kahit tatlong txtbox lang at isa or dalawang command button. medyo complicated na kasi pag inventory na agad e develop mo. tulongan tayo dito ganyan rin ako nong nag simula dito, malayo ma abut natin dito kasi marami contributor sa thread na ito..

 

[peter_p2k]

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

tnx ts ng makapag ugrade naman...

 

[kirby21]

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

sir suggestion ko lang, mag simula ka mag design ng userform kahit tatlong txtbox lang at isa or dalawang command button. medyo complicated na kasi pag inventory na agad e develop mo. tulongan tayo dito ganyan rin ako nong nag simula dito, malayo ma abut natin dito kasi marami contributor sa thread na ito..

ako kasi unang program ko is worker monitoring, second lang yung inventory. mahihirapan ka talaga pag dumeretso ka agad ng inventory. pero trust me pag nakagawa ka ng isa madali na ang mga kasunod.