Sheets Name into array for form dropdown
Hi all.
I'm tring to make a small form with a dropdown list on it, that picks up all sheet tab names in the workbook, while excluding three sheets.
I've never done a form before, so what kind of coding would i need? I.e. a function or a macro?
And i guess the function/macro would need to put the results into a variable array, so then the dropdown box would read it. Is this correct?
Cheers.
Al.
|