You've created the userform, but it looks like you don't have ANY of the code behind it.
I thought your question was how to ensure that each trip is entered sequentially, now I am not so sure. Are you familiar with VBA? Are you wanting specific assistance? or are you looking for some one to write the code for you? Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Rsh <rashmiv.ni...@gmail.com> To: excel-macros@googlegroups.com Sent: Wed, September 21, 2011 3:43:40 AM Subject: $$Excel-Macros$$ Need help to locate data on same row each time i click OK Hi all, I have an excel file in attachment with user form. When I click on Trip1 in / out --- Its respective data gets fitted in cell C6 and D6. Similarly when I click on Trip2 in / out --- Its respective data should get stored in E6 and F6. Constraint: Trip 1 to Trip 6 are sequential.That means, I can fill Trip2 data only after filling Trip1 data. one more example - Trip6 data can be filled only after filling up Trip 1 to Trip 5 data. I need a VBA macro for this. Early help is appreciated... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
