It looks like you're new here. If you want to get involved, click one of these buttons!
I can't figure out how to get my loops to work to pull into list box. Want to calculate distance. User provides speed and hours traveled.
1. Have to prompt user for speed (MPH), must be a whole number greater than zero, if invalid messagebox, exit sub.
2. Have to prompt use for time traveled (hours), must be whole number and greater than zero, if invalid messagebox, exit sub.
Need to code the click events for (4) buttons
BtnA-has to use FOR/NEXT and list items in ascending order
BtnB-has to use FOR/NEXT and list items in descending order
BtnC-has to use DO/WHILE and list items in ascending order
BtnD-has to use DO/UNTIL and list items in descending order
List box results have to use a loop to display the distance the vehicle has traveled for each hour of that time period, like this:
Vehicle Speed: 63 MPH
Distance Traveled: 7 hours
Hours Distance Traveled
Total Distance: 441
Thank you in advance if you can help me...I don't know what I'm doing wrong and I've been working at it for way too long!!