Use multiple variables at the same time

**busterbluth123** · 07-02-2012, 03:27 PM

Is it possible to use multiple variables to create one value? In my case, I'd like to use 2 InputBox commands to ask the user for a "Section" number and a "Page" number, then combine those two to create the sheet name (not add them, but display them as "Section""Page" in the sheet name).

Is this even doable?

**Chippy** · 07-02-2012, 03:42 PM

Something like this (it names the active sheet).

Please Login or Register  to view this content.

**busterbluth123** · 07-03-2012, 02:23 PM

Thank you. That's exactly what I wanted.

**busterbluth123** · 07-07-2012, 03:28 PM

Okay, that part worked out great. Now, I've also got this line:

Range("R30").Formula = (ActiveWorkbook.Sheets("WO Info").Range("WO").Value & suffix)

The value "WO" is set from another sheet in the workbook. This script does set the value correctly when the sheet copies, but I would like to make it be able to change when that original "WO" value is changed on the other sheet. Seems like everything I try just sets the value instead of creating the formula. What am I missing?

Thanks.