Hi

I'm trying to have a command button which works differently depending
on the value in a cell (V3). If the value is 2, I want the button text
to say 'Go to Part 5' and then go to sheet 5 when clicked, or if the
V3 value is 1, I want the button to say 'Go to Part 9' and go to
worksheet 9 when clicked.

Is this possible?

I'd also tried doing it as 2 buttons, one over the other, with the
second being invisible unless the value of V3 = 2.

Would this be easier, and if so, how would I do it?

I'd really be grateful for any advice.

Steve