<div>
Can you supply a sample workbook?
</div>


Format-Control.png

<div>
Of course I completely over looked that, thanks
</div>


Of course I completely over looked that, thanks

<div>
<div class="content wysiwyg-content">
I have an Excel 2003 spread sheet with 2 sheets. &nbsp;One sheet is a form that the 2nd sheet builds from. &nbsp;One the primary sheet (main) I have 2 option buttons. &nbsp;I would somehow like to display a character or text in a cell on the 2nd sheet (Services) based on which option button is selected. &nbsp;<br />
<br />
Is this possible? &nbsp;I can't a way to do this. &nbsp;Thank you.
</div>
</div>


I have an Excel 2003 spread sheet with 2 sheets.  One sheet is a form that the 2nd sheet builds from.  One the primary sheet (main) I have 2 option buttons.  I would somehow like to display a character or text in a cell on the 2nd sheet (Services) based on which option button is selected.  

Is this possible?  I can't a way to do this.  Thank you.

Options Buttons - display selection on another sheet

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.