Creating a dynamic text box

[#1]

Morning all,

I have a text box that i want to autopopulate with the name of the sheet?

Can anyone assist?

Ta

[shraddha_g]

Refer Re: Show Sheet Name on Text Object

[punitpopli]

Hi,

please find the workaround in below :

You change the sheet ID with Name for e.g. SH1 to Activity and follow below syntax

=SubField(GetActiveSheetId(),'\',2)