Change the name of a table using Combobox selection - VBA code

[richard_a]

Hi Guys

I have a combobox on one sheet and a data table on another sheet. I'd like to use the combobox selection and AfterUpdate event to rename the data table (to allow many users to utilise this template and have individually named tables). I've not been able to manage to get it working and wondered if someone could help?

To clarify, I only have 1 table on sheet2

The code below is what I have so far:

Please Login or Register  to view this content.

I've been struggling with this for a few days now so any help would be greatly appreciated. Of course any alternative solutions would also be welcome.

Cheers,

Richard

[BadlySpelledBuoy]

Hi Richard,

Much easier to help if you can attach your workbook (well a sample/desensitized version of) so we can see exactly the type of controls used etc.

BSB