Problem deleting worksheet name as variable from a list

Thank you Norie,

This doesn't seem to be doing it - I'm wondering if the issue is that the "thissheet" is actually a current multipage tab on a form rather than an active worksheet. Would you know the syntax if the ought to be different?

Best regards,

Paul

The list is on a worksheet (definitely a sheet) called "TimeCalc" and is in the range of B29:R29

The items in the list each refer to a created worksheet, which also has a corresponding page (multitab control)

Essentially, we have two button on the multitabbed form - a create button that does the following:

1. Adds a new multitab page (which is a form for user input)
2. Adds a corresponding worksheet which holds the data entered.
3. Adds the worksheet name to the range on TimeCalc

What I'm trying to do with this routing is:

1. Delete the worksheet
2. Delete the current multitab page
3. Remove the current multitab page name from the list in TimeCalc

Eg the creation process in reverse. Steps 1 and 2 work ok, but step three does not, and this is my current problem.

Thanks for your time on this, really appreciated.

Paul

Hi,

It's basically project time estimator, so each page we add is a new project.

Each project has a multipage control, a new sheet in the workbook, and an entry on the list. We can add them but not delete fully.

I'm afraid I can't load an example of the whole workbook up as it contains sensitive data, but have loaded up some screens which should hopefully illustrate what we're trying to do.

thanks,

Paul

We need a separate multipage form for each project to display the data to the user.

The separate corresponding sheets are to help us manage things at the back end. Each sheet is created from a master sheet which is used as a template to insert the data into the corresponding project sheets. I think we could have used a table, but I still think we'd have been faced with the same issue as the TimeCalc list is integral to how the calculations work at the back end..

It's clunky, but the number of sheets doesnt really seem to be a problem, its just carrying this present multipage value over as a value to remove from that list when we hit that delete button.

We want the final users to be able to populate the data without going near the back end, so this is why we're using forms. We're quite a long way down the build of the whole workbook, and can't really redevelop at this stage, but stuck on this list removal routine syntax.

The relationship of the data to the forms is one to many.

So a one-type large table (or currently tables on separate worksheets) on the back end that contains all possible fields, but there are several different types of user form that ask different questions of the inputter, which would rule out a single user form.