| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign cell to checkbox
I have 80 check box in a worksheet.
I wish to assign A1 to check box 1, A2 to check box 2.... so on and so forth. I wrote a stupid code, please assit me with a correct one. Sub Macro1() For i = 1 To 5 ActiveSheet.Shapes("Check Box i").Select With Selection .Value = xlOff .LinkedCell = "Ai" .Display3DShading = False End With Next i End Sub Thanks a lot for ur help !! Boss |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign Color to a Cell based on another Cell on a diff Sheet | Excel Worksheet Functions | |||
| ASSIGN VALUE TO CHECKBOX AND CALCULATE AVERAGE? | New Users to Excel | |||
| I want to place a checkbox in the middle of a cell, yet I want thecheckboxArea take up the entire cell. | Excel Discussion (Misc queries) | |||
| Assign Macro to Checkbox | Excel Programming | |||
| How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
