Hi,
I trying to create a command button, that changes part of it's tex
based on the value of a single cell named range ("InvInvoice"). I hav
tried entering a formula into the Caption property, but couldn't mak
it work.
I then tried grouping a command button and a text box together and i
works, but because the text on the command button centers itself,
have to oversize the command button to make room for the textbox. I
looks klunky.
The static text is "Save and File Invoice #" and the changing text i
the invoice number located in the named range.
Any ideas

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=52274