enter data automatically in userform depending on dropdown selection

**ImboJones** · 07-14-2010, 04:30 AM

Hi,
Right now I have a form that automatically generates a unique ascending number in a text box for each new entry. Ideally I would like it to be a combobox that lists all the previous record numbers as well as generating the new one so that if a previous record number is selected it will automatically enter the relevant information from that previous record into certain boxes on the form.
e.g say I want to go back to journey 00003. I select it from the dropdown list and it enters, among other things, the date of that journey and the destination into the relevant boxes.
TIA!

**romperstomper** · 07-14-2010, 04:40 AM

We would need a lot more information (preferably a sample workbook) to provide meaningful code, but I would suggest you don't combine the two fields, but rather add a combobox to the top of your form to allow searching. You can populate this directly from the ID column of your worksheet and then probably just use its ListIndex property to get the relevant row number.

**blindzero678** · 07-16-2010, 05:27 PM

Originally Posted by ImboJones

e.g say I want to go back to journey 00003. I select it from the dropdown list and it enters, among other things, the date of that journey and the destination into the relevant boxes.
TIA!

I'm actually trying to do something similar, but I cannot figure out how to write the code for the combobox to do this. Could you please help?

thank you!

**romperstomper** · 07-16-2010, 06:55 PM

Please start your own question rather than hijacking this unsolved one.

**foxguy** · 07-18-2010, 12:38 AM

Hi ImboJones;

You put a Cell Link in the combo box and assign a macro to the combo box. Make sure that the 1st item in the list is "NEW #".
In the macro you check the Cell Link, it gives you the row # of the selected item. If the row # is 1 then generate your new #, if the row # is greater than 1 then the # selected should be 1 less than the row # (as long as there aren't any missing), or just take the value of the row # in the list. Then you should be able to populate your form accordingly.