In the code for the option button, place cursor in desired box
textbox5.SetFocus
There are several ways of making them enter something, is there particular
info that must be there or just anything?

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"KCK" wrote in message
...
Hi, I have a worksheet with several optionbuttons (from the control
toolbox).
If a user clicks on a particular optionbutton I need them to enter
information into a particular textbox. Can someone tell me how to make
this
work?
Example: If Optionbutton 5 is clicked, the user should automatically be
placed in Textbox5 and required to enter some information.

Thanks for any help you can provide.