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
Test.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
