Pop up to insert the data in sheet 2

[bittu2010]

Hi,

I want that when I click on “Start time button” and “End & Continue button” then a pop should appear to insert some data in sheet 2. Please see attached.

Pop up (user fourm) should have submit the data command button and after clicking this button all submitted value should insert in sheet 2 automatically.

When It takes the data for the first row then after clicking “End & continue button” it should pop up again to take the data for next row. This cycle should run till the time processor not click on stop button.

I have attached my excel sheet MIS as well as a screen print to clear it more.

Thanks in advance

[john55]

hi,
see the file attached, it's just an option...

[bittu2010]

Hi John,

You are great for help. This is the same I wanted

But it has 2 problem.

First problem- when I am clicking on “Start time button” and “End & Continue button” then pop up appears first and time get started after clicking “GO” button. I want to get pop up and time run at the same time.

Second problem – When pop up get appears I cant write anything and work on “sheet 1” . It should active with pop up so that I can work on sheet 1 while Pop up is working.

Thank you Dear.

[john55]

hi
maybe this

[bittu2010]

It has been done by you..
sorry but last question.. Except the "first trace box" can we validate other boxes with the "YES" and "NO" option in POP UP. Like processor can only select option Yes and NO in next 3 boxes. Please tell me. Thanks

[john55]

yeap,
add 3 comboboxes in yr userform and add this code in userform initialize
and edit the code for "GO" replacing the textboxes with comboboxes.

Please Login or Register  to view this content.

[bittu2010]

Thanks a lot John :-) I wish you all the luck of this world.. I cant explain how great you are.. Thank you Thank You

[john55]

hi man,
glad it helped u!

[bittu2010]

Hi John,

This is my last question. is this possible if any box get blank then it shows some error like "please fill all the boxes " in pop up. Thanks

[john55]

hi bittu,
sure, see this!

Please Login or Register  to view this content.

[bittu2010]

Thank John for all your help.

would you help me in my another thread.. below is link
http://www.excelforum.com/excel-prog...00#post2753700

no one is helping me. Thanks in advance :-)