Counting Numbers

[Liju144]

Hi Friends,


I need to Count the Balance Numbers

example if Textbox1 value is 5 then show the Textbox2 zero.after saving textbox2 value is showing 4 and next time 3 .....0

They Have any option??


Thanks

Liju

[jmac1947]

liju,

I have absolutely no idea what you are trying to achieve??

Post a sample workbook with your current code attempts, sample data and expected results

That may make it easier to help you

[G e r a r d]

You can put a counter in a hidden cell of worksheet.

In the Workbook_BeforeSave you can:

1. reduce the counter with 1 until you hit 0
2. Set new value for textbox1
3. Set new value for textbox2

During opening the workbook (Workbook_open ?) you can set the value you want for the text boxes...

[Liju144]

Dear Friends,


Am attaching the Workbook to your reference Kindly check & Give me a solution for this .

conditions:- when enter the Maximum Value In text column then show balance count as .
After click save show the balnce count want to decrease one.
when it will come -ve value then disable the save button.

[G e r a r d]

Please Login or Register  to view this content.

[Liju144]

Thank you,

Friend the textbox2 is a manuval entry option i give a example of that the value is 5 may be that value will be change .

Thanks
Liju M

[G e r a r d]

OK this one initial sets the textbox2 to 5, but it can still be changed until save button is pushed. After save the value is locked.

Please Login or Register  to view this content.