I mean cell (not box - sorry!).

"Shane Devenshire" wrote:

Hi,

When you say "put in a certain box" what do you mean by box? Is this a cell
in the spreadsheet or an input box on a user form in VBA, or do you have a
Control Toolbox "text box" in your spreadsheet, or do you have a Form "Label"
in your spreadsheet?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Barbara" wrote:

I have a workbook with multiple worksheets. I want to enter a formula in
certain cells that will automatically put whatever text I put in a certain
box into all the worksheets. For instance, if I type in the Agency Name, I
want it to go into that cell in each worksheet. Can anyone tell me how to do
that?

Thanks