| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option Box
I am quite new to visual basic. I have created an option box. How can I tell it to print a number say "53" into cell B6 when I click on it? thanks in advance -- harksteve ------------------------------------------------------------------------ harksteve's Profile: http://www.excelforum.com/member.php...o&userid=30483 View this thread: http://www.excelforum.com/showthread...hreadid=501402 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Option Box
In the click event in VB you would put something like:
range("b6").value = 53 "harksteve" wrote: I am quite new to visual basic. I have created an option box. How can I tell it to print a number say "53" into cell B6 when I click on it? thanks in advance -- harksteve ------------------------------------------------------------------------ harksteve's Profile: http://www.excelforum.com/member.php...o&userid=30483 View this thread: http://www.excelforum.com/showthread...hreadid=501402 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Button Help | Excel Worksheet Functions | |||
| the option "sent to" mail recipient is not available in excel 200 | Excel Discussion (Misc queries) | |||
| Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) | |||
| Second option button disappears when I make another column | Excel Worksheet Functions | |||
| Filter option | Excel Discussion (Misc queries) | |||
Linear Mode
