i need a user form to Check daily Stock! ... i got a user form a bit similar to what i want, from this very forum ... but i want couple of changes in it .. i myself tried a lot to get it done .. but invariably end up with no success..
Hope you guys would help me out! THANK YOU all IN Advance ..!
Now what all changes i want to make in it, are as follows :-
1) When i run the macro by clicking on the SELECT STOCK button, there is an option SELECT SHEET , as there is only one sheet (Stock), i want it to pick it up by default .
2) Now when i select the code .. it shows up all the data relevant with that code .. Size n quantity, in a below grid .
Now when i select a particular size under that code in a below grid .. It highlights the complete row, and tab Secure becomes Active & when i press it (Secure Tab) .. it copies the highlighted data to sheet 1! .. I do not need this at all .. instead of this .. i want when i click on the Secure TAb .. it pops out a new sub form ... asking "HOW MUCH PAIRS OUT OF (AVAILABLE (VALUE)) DO YOU WANT TO SECURE FOR YOURSELF" ..AND when i fill up the numeric value in it ..
it automatically deduct it from the quantity against that code n size in sheet(Stock) ..!
THAnk you all in advance once more ...!
fIND THEREIN AN ATTACHMENT FILE ....
http://www.excelforum.com/excel-programming/675533-stock-checker-user-form-help.html#post2057569
Hope you guys would help me out! THANK YOU all IN Advance ..!
Now what all changes i want to make in it, are as follows :-
1) When i run the macro by clicking on the SELECT STOCK button, there is an option SELECT SHEET , as there is only one sheet (Stock), i want it to pick it up by default .
2) Now when i select the code .. it shows up all the data relevant with that code .. Size n quantity, in a below grid .
Now when i select a particular size under that code in a below grid .. It highlights the complete row, and tab Secure becomes Active & when i press it (Secure Tab) .. it copies the highlighted data to sheet 1! .. I do not need this at all .. instead of this .. i want when i click on the Secure TAb .. it pops out a new sub form ... asking "HOW MUCH PAIRS OUT OF (AVAILABLE (VALUE)) DO YOU WANT TO SECURE FOR YOURSELF" ..AND when i fill up the numeric value in it ..
it automatically deduct it from the quantity against that code n size in sheet(Stock) ..!
THAnk you all in advance once more ...!
fIND THEREIN AN ATTACHMENT FILE ....
http://www.excelforum.com/excel-programming/675533-stock-checker-user-form-help.html#post2057569