I have a workbook with worksheets. The first is a plan for a quoter and other
3 are
monthly reports. Each report sheet has 2 textboxes, one for month and one
for year.
Textboxes receive data from respective linked cells.
Both text boxes receive data from the linked cell which have formulas to
select a month and a Year.
I tried several codes which work perfectly when you enter the data directly
into the text boxes (or directly into the cell for the name of the worksheet
if you want to rename cell from the range). But when I tried to use formula
in the linked cell it stopped to work.
Could you please help me to have report tabs renamed automatically when
values of the linked cells (or text boxes) are changed by formula.
Thanks/Vladimir