stock checker user form .. Help!

[dollar]

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 ...!

[dollar]

ain't nobody have any solution ? :-(

[dominicb]

Cross posted :
http://www.mrexcel.com/forum/showthread.php?t=377670

Although I like the fact that you point Mr Excel forum users to our forum 'cos they don't allow attachments.

Ten out of ten for cheek, matey ...

DominicB

[royUK]

Thread locked - OP has a complete disregard for Forum Rules. Your stock sheet isn't even designed to be able to use a form easiy

Cross posting
PM'ing questions