user input single selection using range use combobox/ListBox

[iggypop]

Hello All, I have a spreadsheet template (Template Input) where I could Backup the template to another sheet (Template Backup) (1 row per template) based on template name supplied by user input. I have set column "A" of Template Backup sheet to an array TempName with refers to=OFFSET(Template Backup!$A$2,0,0,MAX(COUNT(Sheet1!$A:$A),1),1).

A B C
1 TempName Task# RITM#
2 Blank N/A N/A
3 IanW TASK2212788 RITM1689676
4 Melissa TASK2025699 RITM1529465
5 DavidP TASK2054857 RITM1554441

Now to restore a template I have a simple user input box to say what template name you want to restore, which works fine for me since I know which templates were created and the name used, or the next person can go to the template backup sheet look at the names and go back to the form to run the restore macro (obviously not very functional or user friendly).

My idea was to create and user input box listing the template names available to restore and have the user select the 1 then need, not sure how to do this and what to use a Combo Box or List Box or something else all together?

[Mumps1]

Try the attached file. Keep in mind that when you backup a template name, it adds it to the bottom of Template Backup. This can create duplicate Template Names in the Backup. If you want to replace the existing Template name in backup, please let me know and I will modify the macro. Click on A30 or B30 in the Input sheet and select a name.

[iggypop]

Thank you Mumps1, works well on your spreadsheet not on mine, keep getting an error when I choose a name to restore "Ambiguous name detected: worksheet_change

Also, I wanted to keep the user input function for the Template Backup cause they can backup multiple templates under the same name ie. Alan prj1, Alan prj2...

I am wondering, can you have more than 1 worksheet change on a sheet, I already have a worksheet change for my multi-select drop down list, could that be the issue?

Hi Mumps1, I was correct, seems the issue is that I already have a worksheet event for my input tab, it is used for rows B14, B15 & B16, it allows those cells to allow for multiple names if required, ie. approver1, approver 2, approver3 (when an order is over the first approvers limit, then the next higher approver is added ....etc).

I took the liberty of adding my worksheet event to your spreadsheet and received the same error message, I have looked at the code but I am not sure how to merge then, but will keep trying.

[Mumps1]

You can have only one Worksheet_Change event. I combined both events into one.

[iggypop]

Wow, that is beautiful, thank you Mumps1, works like a charm, fast and much more efficient, much appreciated, sorry, wish I could give more reps but it will not let me.

[Mumps1]

My pleasure.