the textbox's value and the excel cell's value summation

**bskaa** · 06-21-2013, 05:04 AM

Hi all,
I'm trying to make a stock software with VBA. But I have a problem.
I need to show the available amount on the sheet1 in the excel file. For this, in the userform1, according to material's name ( Combobox1), the amount (T3 textbox value) sum with E column related row.
Exactly, I write a formula but it is wrong. However, to explain what I mean, I copy the formula following;

Please Login or Register  to view this content.

Note: sayfa1 = sheet1

Thank you...

**zbor** · 06-21-2013, 05:05 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

**:) Sixthsense :)** · 06-21-2013, 05:14 AM

May be this...

Please Login or Register  to view this content.

**:) Sixthsense :)** · 06-21-2013, 05:26 AM

Sorry zbor not refreshed the screen

**zbor** · 06-21-2013, 05:29 AM

There were code tags before refreshing?

**:) Sixthsense :)** · 06-21-2013, 05:32 AM

Ah! I am not talking about that I said not seen your post

**bskaa** · 06-21-2013, 05:32 AM

Hi all,
I'm trying to make a stock software with VBA. But I have a problem.
I need to show the available amount on the sheet1 in the excel file. For this, in the userform1, according to material's name ( Combobox1), the amount (T3 textbox value) sum with E column related row.
Exactly, I write a formula but it is wrong. However, to explain what I mean, I copy the formula following;

Please Login or Register  to view this content.

Note: sayfa1 = sheet1

Sorry....

**zbor** · 06-21-2013, 05:37 AM

bskaa, you could just edit first post (I did that now for you).
Check Sixthsense's solution it's restored now.

**zbor** · 06-21-2013, 05:38 AM

Originally Posted by :) Sixthsense :)

Ah! I am not talking about that I said not seen your post

I still don't understand why would someone answer in thread that is against rules anyway?!?!

**:) Sixthsense :)** · 06-21-2013, 05:40 AM

One error in my suggested code in post #3

Replace

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

**:) Sixthsense :)** · 06-21-2013, 05:48 AM

Originally Posted by zbor

I still don't understand why would someone answer in thread that is against rules anyway?!?!

In fact it's not happening knowingly... Because we have to check the Thread Name and any Mod/Adm req and OP's Requirement and side by side updates on other posts so moving between threads and one is like formula solution and one is like code solution. Again resuming the code and pressing F5 to refresh the screen and doing the Office Work. Don't know what to say more than this

**bskaa** · 06-21-2013, 05:49 AM

Hi, I forget to loud excel file. How can I loud the file? I couldn't do it.

**bskaa** · 06-21-2013, 05:52 AM

I did it. sorry again.

**john55** · 06-21-2013, 05:54 AM

Originally Posted by :) Sixthsense :)

.... Again resuming the code and pressing F5 to refresh the screen and doing the Office Work. Don't know what to say more than this

and yr boss says "my employees use their time 100% ...."

)

**bskaa** · 06-21-2013, 05:58 AM

Hi Sixthsence, I changed the code as you write above. But it doesn't run. I sent the file. Could you look at VBA codes?
Thank you?

**zbor** · 06-21-2013, 06:04 AM

Originally Posted by john55

and yr boss says "my employees use their time 100% ...."

)

And that's a true

you_should_give_100_at_work_tee-r6eb4fba580aa4dcbbac15840778ca3f5_804gs_512.jpg

**:) Sixthsense :)** · 06-21-2013, 06:05 AM

May be try this one....

Please Login or Register  to view this content.

**:) Sixthsense :)** · 06-21-2013, 06:08 AM

Originally Posted by john55

and yr boss says "my employees use their time 100% ...."

)

ha ha ha lol

**:) Sixthsense :)** · 06-21-2013, 06:12 AM

Originally Posted by zbor

And that's a true

In fact there is no such practices are followed here... If you do your work in an hour or for a whole day that is not an issue you will be paid only same amount. No boosting up actions they will take... just do the allotted work and move away to your home...

**bskaa** · 06-21-2013, 06:21 AM

hata1.jpgIt doesn't.

**:) Sixthsense :)** · 06-21-2013, 06:26 AM

Add a dot(.) before the word cells and check

**bskaa** · 06-21-2013, 06:33 AM

Formula:

Please Login or Register  to view this content.

It still doesn't run.

**:) Sixthsense :)** · 06-21-2013, 06:40 AM

It should be COUNT lol

**bskaa** · 06-21-2013, 06:43 AM

ok. Thank you very much...

**bskaa** · 06-21-2013, 07:41 AM

Hi,
the codes which you sent are run. However I want a relation between incoming form and outgoing form.
For example;
Material name is "Ampul". 10 Ampuls are came in our stock, in same day, 5 ampuls are get out from the stock. I need to see that the available amount (sheet1, column E) is 5. But I couldn't. What should the code? Could you help me?
Thank you...stok durumu2x (2).xlsm

the textbox's value and the excel cell's value summation

LinkBack

Thread Tools

Rate This Thread

Display

the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Re: the textbox's value and the excel cell's value summation

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions