#1
|
|||
|
|||
example of radio buttons in for data entry?
I want to use a radio button to enter data into a cell. So, if OptionButton1 is pressed enter 1. if OptionButton2 is pressed enter 2...etc. Is there example code for this anywhere?
Also, should I use a form control or an ActiveX control? In the toolbox, I see a frame for the form control selection, but none for ActiveX control. How do I group ActiveX buttons? |
#2
|
||||
|
||||
If you use forms controls you will not need code to put the number into the cell. You can right click > format control > control tab > cell link - choose the cell you want to link to.
The general rule of thumb is that, if you must put controls on a worksheet (as opposed to a userform), then use the simpler 'forms' controls. There's less that can go wrong with them. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help! I can't get the buttons to work! | Alicia | PowerPoint | 0 | 02-19-2011 01:48 PM |
Options Buttons become inactive | clint | Word | 0 | 02-25-2010 04:31 PM |
command buttons | ronf | Excel | 0 | 04-28-2006 08:32 AM |
command buttons | ronf | Excel | 0 | 12-03-2005 06:26 AM |
Radio (options button) problem | Niros | Excel | 1 | 11-24-2005 09:58 AM |