| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract number from name of cell
I want to rename a cell that contains a control checkbox. the checkbox is named Checkbox2. I want to rename the cell "Box2". How do I extract the 2 from "Box2" so that I can use this in a loop?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extract number from name of cell
This is an example of what I already have for my checkboxes. I would like to do something like this for my renamed cells such as Box2. Thanks. Mat
Dim nChkNum As Intege For Each ole In OLEObject If TypeOf ole.Object Is MSForms.Checkbox The nChkNum = CInt(Mid$(ole.Name, Len("Checkbox") + 1)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract everything to the right in cell when a number is encounter | Excel Worksheet Functions | |||
| How to extract each digit from a number in one cell? | Excel Discussion (Misc queries) | |||
| how do i extract a number from a cell with no spaces? | Excel Worksheet Functions | |||
| Extract sheet name/number to cell | Excel Discussion (Misc queries) | |||
| Extract number in middle of cell | Excel Worksheet Functions | |||
Hybrid Mode
