filling forms

[TravisT81]

I'm very new to coding in VB, but I've learned a bunch of basics in a little bit of time. I'm currently struggling to get one thing working and can't seem to find the solution.

I have a spreadsheet I'm using to track engine modifications to my drag car. I'm saving each configuration as a "profile" and the form which I am entering the info started with a text box to "name" the profile. Since I typically change one of the 20+ items I'm tracking at a time, I would like to be able to select a "profile" that has already been created and modify an item or two, then save the updated profile with a new name. I think this can be done with a combo box, but I can't figure out how to pull the info created in the spreadsheet and insert it into the form. I'll be happy to attach a file if my explination doesn't make sense. Thanks for any help you can provide!

TravisT

[royUK]

Are you referring to UserForm?

Explain what you mean by "profile"

[TravisT81]

Yes I am referring to a userform. The profile, in laymans terms would be the tires, shocks, springs, and air pressure I run at a certain time.

Typically when I make changes at the dragstrip, I will only make one change at a time, and based on data collected during each race I would make adjustments for the fastest time. Each "change" would be a new profile, unless all fields exactly matched another row in the database.

Attached is the spreadsheet I've been working on. The three sheets included are "main" which links to the userforms, a timeslip sheet which is where timeslip data is recorded and the "profile" sheet where the vehicle profiles are kept. I think my goal will be easier to understand once you take a look...

Thanks for the help!

[royUK]

Use the ComboBox_Change event & the ComboBox ListIndex. The ListIndex starts at zero & your data starts in row 3 so you need to add 3 to the ListIndex

Please Login or Register  to view this content.

[TravisT81]

Worked Great! Thanks for the help!

[royUK]

Glad it helped. You can use a similar method to amend records