Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I add an option button in Excel
I am trying to make a monthly check list where each cell represents one day
of the month and in each cell (day) I would like to put an option button. any suggestion. thanks MO. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I add an option button in Excel
Hi MO,
Try: '============= Public Sub InsertOptionButtons() Dim c As Range Application.ScreenUpdating = False For Each c In Selection With ActiveSheet.OptionButtons. _ Add(c.Left + 5, c.Top - 2, 5, 5) .Caption = "" .LinkedCell = c.Address(False, False) End With c.Font.Color = vbWhite Next c Application.ScreenUpdating = True End Sub '<<============= --- Regards, Norman "MO" wrote in message ... I am trying to make a monthly check list where each cell represents one day of the month and in each cell (day) I would like to put an option button. any suggestion. thanks MO. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel- option button | Excel Worksheet Functions | |||
Excel 2002 has no option to add the save as button to the toolbar- | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
In excel how do I delete an option button form already in worksht | Excel Discussion (Misc queries) | |||
how to access a value from excel option button using visual basic? | Excel Programming |